I am using vlookup formula in excel, my table reference jumps from 0 to 30 and I want my formula to pick up 24 (so nearest), but it still returns total 0. It's only picking up exact values with either TRUE or FALSE.
e.g. 0 = 0%, 29=8%, 30=10%
=VLOOKUP(H8,Table1,2,TRUE)*($D$8:$D$13) (This works for my exact values only) Why??
Please help.
Solved by K. C. in 17 mins