title: LOOKUP function in Excel is throwing #NA error
body: <p>I am using <code>LOOKUP()</code> function in Excel. However, it is throwing an <code>#NA</code> error. Does excel throw an NA error if the data to be compared is very small?</p>
  
  <p>Here is the data I am checking :</p>
  
  <pre><code>0.02
  0.03
  0.04
  0.05
  0.06
  0.006
  0.6
  </code></pre>
  
  <p>I was using the following command : =<code>LOOKUP(0.006,F28:F34,G28:G34)</code> which threw  the <code>#NA</code> error.</p>
  
  <p>If I use any other data for instance 0.02 or something, It gives the right answer.</p>
  
  <p>Am I doing something wrong ?</p>