Vlookup And Lookup Functions

  • Thread starter Thread starter Chuckles123
  • Start date Start date
C

Chuckles123

Is there any work-around to get VLOOKUP and LOOKUP functions to retur
the first cell that exceeds the lookup_value as opposed to the las
cell that is less than the lookup_value?

Thanks for a response,
Chuckles12
 
If the data is sorted descending, VLOOKUP will work.

Otherwise, with the data sorted ascending,

=INDEX(A:A,MATCH(Target,A:A))+1)

Note that this formula will never return Target unless it occurs more than
once in the list.
 
Back
Top