title: VLOOKUP with two criteria
body: <p>I have two tables, Purchases and Sales:</p>
  
  <p>Purchases:</p>
  
  <p>SKU&nbsp;&nbsp;&nbsp;&nbsp;SID&nbsp;&nbsp;&nbsp;&nbsp;NID&nbsp;&nbsp;&nbsp;Cost<br>
  001&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;A1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;9A&nbsp;&nbsp;&nbsp;&nbsp;$1.07<br>
  001&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;A2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;4A&nbsp;&nbsp;&nbsp;&nbsp;$1.07<br>
  002&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;A1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;5B&nbsp;&nbsp;&nbsp;&nbsp;$2.24</p>
  
  <p>Sales:</p>
  
  <p>SKU&nbsp;&nbsp;&nbsp;&nbsp;SID&nbsp;&nbsp;&nbsp;&nbsp;NID&nbsp;&nbsp;&nbsp;Sale<br>
  001&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;A2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;$10.99<br>
  001&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;A1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;$9.99<br></p>
  
  <p>So, I want to do a VLOOKUP in the "NID" column of Sales to get the "NID" from the Purchases sheet where the "SKU" and "SID" from the Purchases sheet match the "SKU" and "SID" in the Sales sheet.  </p>
  
  <p>I can match on one of the two.  For example, I could do this to match on the SKU alone:</p>
  
  <pre><code>VLOOKUP(A2,Purchases!$A:$D,3,FALSE)
  </code></pre>
  
  <p>But, I'd need to also match on "SID" since there are different values for "NID" based on a combo of "SKU" and "SID."  If there's a better option than VLOOKUP, that's fine too.  Thanks!</p>