Vlookup And Lookup Functions

[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

 

[Myrna Larson]

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.