Hi
Your formula Vlookup "Range Lookup" is it set to "False" exact match, if so then
it looks like a rounding error. just for trial switch the function to "True" and
see what you get.
HTH
John
"iguttin" wrote in message
...
The numbers I'm using for the table and within the lookup were generated
using a formula (ie. value above + 0.05%) so they don't have empty spaces.

"John" wrote:

Hi
Maybe its just a empty space before your numbers,you can't see it but will
give
you in return #na as a result. Check it
HTH
John

"iguttin" wrote in message
...
I've tried rounding both the lookup table and the value in case this was a
rounding issue.

The stranger thing is that VLOOKUP works for *most* values, but every 4th
(or 8TH) value errors out. (eg. looking up 101.35% works, 101.40% works,
101.45% works but 101.50% doesn't)