lookup number greater than

[Ade Taiwo]

I want to Look in a one-row or one-column range for a value and return a
value from the same position in a second one-row or one-column range, but
instead of returning the largest value in lookup_vector that is less than or
equal to lookup_value I want to return the largest value in lookup_vector
that is greater than or equal to the lookup_value.

 

[Luke M]

"largest value in lookup_vector that is greater than or equal to the
lookup_value"

This, no matter what your lookup_value is, will always be equal to:
=MAX(lookup_vector)