=INDEX($B$14:$B$77,MATCH(MIN(IF($F$14:$F$7750,$F$ 14:$F$77)),$F$14:$F$77,0))
which must be confirmed with control+shift+enter, not just with enter.
Tim wrote:
Hi,
Is there any way that I can get lookup or an equivalent to use the next
value that is GREATER than the lookup value?
My data is not sorted and can not be sorted.
Other data is as follow:
Lookup value: 50
lookup_array:F14:F77
Resulting value: B14:B77
Tim
|