need to select closest match using vlookup if it higher or lower
 

i cant get vlookup to select the closest value if the closest value is higher
it automatically selects the highest value below the cell value

need to select closest match using vlookup if it higher or lower
 

VLOOKUP() will not do what you want. You can use MATCH() and INDEX(), if the
list is sorted in descending order and you use -1 as the 3rd argument in the
MATCH() function


"vlookup help pls" wrote:

i cant get vlookup to select the closest value if the closest value is higher
it automatically selects the highest value below the cell value