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!

Register Yourself Login