Lookup Next Highest Value

  • What is the best formula or method to use Vertical Lookup to get the next higher number if it's not equal versus getting the next lower value?

  • Re: Use Vertical Lookup to Get the the next Higher Value


    You would be better served using an Index/Match formula and using the match type argument of -1, which requires the lookup array to be sorted in descending order.


    Say for example you wanted to look up the value of cell A1 and the lookup table is a two-column table in the range D1:E10 and the table is sorted in descending order by the first column (which is where we'll look for a match).


    =INDEX($E$1:$E$10,MATCH(A1,$D$1:$D$10,-1))

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!