Format ColumnA with many decimals and see if it's not actually slightly
smaller than 101%
Do you actually use the formula as shown or do you refer to a cell
containing the 101%?

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"KevinM" wrote in message
...
I just took over a spreadsheet from a coworker and i noticed they are
trying to use a vlookup and it is returning the wrong value. I have
two values on a spreadsheet for 101.1% and 101.0% but when i do the
vlookup i get different numbers. Any help would be much appreciated

For 101.1% it will return the value of $5 which is correct.

For 101% it returns $0 which is incorrect as it should return back $5
too.


Here is the formula I am using
=VLOOKUP(101%,ColumnA,3,TRUE)

Table A
Column A Column B Column C
100% 100.99% $0
101% 101.99% $5
102% 102.99% $10
103% 103.99% $15