Thread: need to select closest match using vlookup if it higher or lower
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Duke Carey
 
Posts: n/a
Default 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
Reply With QuoteReply With Quote