I have no clue why but if you change the formula in cell B1 to be something
like the following it should work. (I guess you can adjust the # of digits
to round by)

=ROUND(A1+0.01,2)

Hope this helps.

Thanks,
Bill Horton

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