lookup number greater than
 

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.

lookup number greater than
 

"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)
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Ade Taiwo" wrote:

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.