reverse range lookup/VLOOKUP

[Jon Turow]

Is there a way to create a formula that functions the same
as =VLOOKUP(A1,My_Range,2,TRUE), except with vlookup's
range lookup finding the next *highest* number instead of
the next lowest?

 

[Harlan Grove]

Is there a way to create a formula that functions the same
as =VLOOKUP(A1,My_Range,2,TRUE), except with vlookup's
range lookup finding the next *highest* number instead of
the next lowest?

=INDEX(MyRange,MATCH(A1,INDEX(MyRange,0,1))+(VLOOKUP(A1,MyRange,1)<>A1),2)