View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
JJ
 
Posts: n/a
Default Excel System Error???

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?