title: Run two vlookup if an 'N/A'
body: <p>I am currently in the process of trying to create a vlookup function that will check cell A2 and check it on sheet1. If it brings back an error, it should go to B2 and then check on sheet1 and bring back the results.</p>
  
  <p>This is what i currently have:</p>
  
  <pre><code>=IF(ISNA(VLOOKUP(A2,'Sheet1'!$A$2:$A$1932,1,FALSE)),"0",VLOOKUP(B2,'Sheet1'!$A$2:$A$1932,1,FALSE))
  </code></pre>
  
  <p>But it doesn't seem to be bringing back all the results, it is bringing back some results from each list A2 and B2.</p>
  
  <p>What am i doing wrong?</p>
  
  <p>Thanks in advance.</p>