reverse range lookup/VLOOKUP

  • Thread starter Thread starter Jon Turow
  • Start date Start date
J

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?
 
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?
Click to expand...

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