title: Excel - VLOOKUP returning #VALUE
body: <p>Yesterday I asked <a href="https://stackoverflow.com/questions/15825429/excel-mutiple-ifs-in-one-cell">this</a> question. I tried out another VLOOKUP formula seeing how useful it was, but have run into a very strange error I can't seem to fix.
  I have the following row of data</p>
  
  <pre><code>Probabilities| 1%, 1.9%, 4.6%, 9.3%, 16.2%, 25.9%, 37.5%, 50%, 62.5%, 74.1%, 83.8%, 90.7%, 95.4%, 98.1%
  </code></pre>
  
  <p>Each item is in it's own cell on a separate sheet called "Probability". On my first sheet I have <code>=VLOOKUP("Probabilities",Probability!$A$1:$O$1,A2+1,FALSE)</code> where A2 is a number between 3 and 17. If A2 is 1, then I get the row header, "Probabilities". If A2 is >= 2 I get <code>error: Argument out of range: &lt;Whatever A2 is +1&gt;</code>. I've tried everything from adding headers, changing the tables values to just integers or specifically <code>="&lt;some text&gt;"</code> so see if it didn't like the % symbol. The cell A2 is the result of another formula, so I tried to just type the numbers directly into the cell as well, and replacing A2 in the formula with a number. I'm guessing the issue is not with the index. But I just don't know what. Thanks in advance for the help. Let me know if more info is needed</p>