VLOOKUP Function

[ashoulds]

is there a way to have a Vlookup function return the next largest value if an
exact match is not found? Currently, it will only return the greatest value
equal to or less than the value?

 

[Sheeloo]

Can you give an example? To me 'next largest value' and 'greatest value equal
to or less than' mean the same.

There is no way to change the behaviour of VLOOKUP unless you write your own
verision in VBA...