lookup number greater than

  • Thread starter Thread starter Ade Taiwo
  • Start date Start date
A

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.
 
"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)
 
Back
Top