If you want to see the internal representation of these numbers more
precisely, try my functions from
http://groups.google.com/group/micro...fb95785d1eaff5

Specifically, you will find that 14%+0.01 does not have the same internal
representation as 15%, since none of these 3 decimal fractions have exact
binary representations (just as 1/3 has no exact decimal representation).

You cannot directly see the difference, because Excel will only display 15
digits, but you can see it by subtraction,
=(14%+0.01-15%)
returns 2.77555756156289E-17, which is the difference that VLOOKUP is
recognizing.

Jerry

"JJ" wrote:

I have a simple vlookup function that works sometimes and not other times.
Please check this out for me. I am totally lost on this one. I use excel
2002. Try this out...

A1: =14%
B1: =A1+0.01
C1: =VLOOKUP(B1,D:E,2,FALSE)
D1: =15%
D2: =16%
E1: =3%
E2: =4%

I get an error #N/A on cell C1. However if I change B1 to be =A1+.02, the
formula works. Also, if I just type in 15% into B1 it works.....confused?