title: Excel VLOOKUP with 2 Search Values
body: <p>I have a formula that acts as VLOOKUP with two values. It looks for x in column A and y in column B, when both found on the same row it returns the value in column C. The problem with this formula is that it doesn't stop calculating, each time I change a value in any field (not just A, B or C) or just scroll down the page it starts calculating making it impossible to use.</p>
  
  <p>The formula is ended with Ctrl + Shift + Return </p>
  
  <pre><code>{=INDEX(C:C;MATCH("x"&amp;"y";A1:A99&amp;B1:B99;0))}
  </code></pre>
  
  <p>Anybody know how to get the same result without slowing excel down.</p>
  
  <p>Thanks,
  Gareth</p>