title: IFERROR(VLOOKUP) Formula returns incorrect data in certain cells and correct data in others
body: <p>I'm using the following formula:</p>
  
  <pre>
  =IFERROR(VLOOKUP($A42,SHEET2!$A$2:$N$91,11,FALSE),"")
  </pre>
  
  <p>Of the 100 plus rows of data, the formula has returned correct data. For the cells where the formula returns incorrect data, it appears that data from the preceeding cell (which had returned a correct value) is being returned.</p>
  
  <p>For example, if in column 11 of SHEET2, the VLOOKUP value weight for product #246 is 0.04. Products #247-#300 should return the weight of 0.02. However, the formula returns 0.04.</p>
  
  <p>I've painted the format for the cells that work on each sheet over the cells that haven't been working. Nothing has changed.</p>
  
  <p>Any ideas?</p>