title: Excel VLOOKUP to compare 2 sheets
body: <p>I am trying to use a VLOOKUP to compare 2 sheets of data. I need to see if there is missing data in one of the sheets.</p>
  
  <p>the VLOOKUP I have so far is</p>
  
  <pre><code>=IF(ISERROR(VLOOKUP(B3,Sheet1!$I$2:$I$2234,9,FALSE)),"MISSING FROM OTHER SHEET","")
  </code></pre>
  
  <p>But this just shows "MISSING FROM OTHER SHEET" for all rows, even though I have manually checked and can see some that are in both sheets.</p>
  
  <p>Anybody any idea why this doesnt work?</p>
  
  <p>B column contains a list of order numbers and the I column in sheet 1 contains a list of what appears to be the same order numbers. But with some discrepancies.</p>
  
  <p>I am putting the formula into sheet 2, the column containing the order IDs in sheet 2 is "B", I am checking the data in sheet 1 to see if there are any missing orders in it and the column for order IDs in sheet 1 is "i"</p>
  
  <p>I've checked some other answers here which is where I got my formula from but nothing really solves my problem.</p>