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

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)

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

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)

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

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" 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)

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

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)

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

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)