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

  • Thread starter vlookup help pls
  • Start date
V

vlookup help pls

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
 
D

Duke Carey

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
 
Top