I cant figure out what I am doing wrong.
Why wont my lookup bring me back 2.7 ?
This is what Im getting:

If I do =VLOOKUP(a6*100,a1:b4,2) = 2.5
or if I do =VLOOKUP(a6*100,a1:b4,2,0) = #N/A
a b
1 6.875 -2.375
2 7.000 -2.500
3 7.125 -2.750
4 7.250 -3.375
5
6 7.125%