K
KevinM
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
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