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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Vlookup 6
column to column 5
Vlookup with an exact match 1
Lookup doesn't return what I want; alternative? 5
Sort Absolute Values 2
Match 9 to 11 digits - vlookup 3
How to determine the closest degree? 2
Find closest match and return next highest number in range 4

Back
Top