Excel: VLOOKUP returns #N/A for a sorted value that exists?? WHY?

[iguttin]

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)

 

[John]

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

 

[jaf]

Hi,
Probably still a rounding error.
The default vlookup is >=.
So if the cell value is 101.499999999 but displays 101.50 Excel will return the 101.45%


John

 

[iguttin]

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]

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