VLOOKUP FUNCTION

[ashoulds]

Is there a way to return the next largest value using a vlookup function when
an exact match is not found? As of now, it keeps returning the value that
matches or the next smallest value.

 

[Daniel.C]

An ugly one :
=IF(ISNA(VLOOKUP(C1,A1:B10,2,0)),INDEX(A1:B10,MATCH(C1,A1:A10,1)+1,2),VLOOKUP(C1,A1:B10,2,0))
Regards.
Daniel

 

[ashoulds]

Thank you so much. You rock! Now I think I have it all figured out!