title: Excel IFERROR evaluates #VALUE and returns number
body: <p><a href="https://i.stack.imgur.com/wQozo.jpg" rel="nofollow noreferrer">Screenshot showing #VALUE</a>
  <a href="https://i.stack.imgur.com/ydnYE.jpg" rel="nofollow noreferrer">Screenshot of Answer from'Evaluate Formula' Window</a></p>
  
  <p>My equation in the cell returns a number when it should be blank. When evaluating the formula, it seems it should be blank since the IFERROR function evaluates #VALUE but still returns a number. Here is the original formula: </p>
  
  <pre><code>{=IFERROR(INDEX($F$64:$F$1000,SMALL(IF(AND($G64:G64=$R$2,$A$64:A64&gt;=($A$64-6)),ROW($F$64:$F$1000)-MIN(ROW($F$64:$F$1000))+1),ROWS($J$15:J15))),"")} 
  </code></pre>
  
  <p>Thank you for any help you can provide. </p>