title: How to check if cells in a row are equal to another row in other sheet
body: <p>So I have 2 sheets being for example:</p>
  
  <h2>Sheet1:</h2>
  
  <pre><code>-------------
  |   | A | B |
  -------------
  | 1 | x | y |
  -------------
  | 2 | z | w |
  -------------
  </code></pre>
  
  <h2>Sheet2:</h2>
  
  <pre><code>-------------
  |   | A | B |
  -------------
  | 1 | n | u |
  -------------
  |...|...|...|
  -------------
  | 7 | x | y |
  -------------
  </code></pre>
  
  <p>I want to check (like vlookup) if Sheet1's A1 is in Sheet2 A column and if it is check if next cell from Sheet2 (lets say it encounters in A7, check if B7 is equal to Sheet1's B1) is equal to Sheet1's B1 return true if encounters equal row and else if it doesn't. Also I know Sheet1 positioning but not Sheet2</p>
  
  <h2>Update</h2>
  
  <p>So, I've been looking and trying and I manage to come up with a formula that makes sense to me but somehow it is not working:</p>
  
  <pre><code>=IF(SD!A2 = Spectrum!A:A &amp; SD!B2 = INDEX(Spectrum!B:B,MATCH(SD!A2,Spectrum!A:A,0)) &amp; SD!C2 = INDEX(Spectrum!C:C,MATCH(SD!A2,Spectrum!A:A,0)), "True", "False")
  </code></pre>
  
  <p>Can anyone tell me whats wrong with it, only returns false and i've looked in the sheets and it should return true.</p>