Vlookup function help
Posted by Ken on November 20, 2001 3:33 PM
Assume that my range
B2 contains 6.3
B3 contains 7.5
B4 contains 8.0 and so on...
Column B is sorted in an ascending order. My lookup value is 7.3.
If VLOOKUP can't find lookup_value, and range_lookup is TRUE, it uses the largest value that is less than or equal to lookup_value. So it return 6.3.
Can I get the nearest value to the lookup value?
Thank you