lookup finding the next value that is GREATER

T

Tim

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
 
A

Aladin Akyurek

=INDEX($B$14:$B$77,MATCH(MIN(IF($F$14:$F$77>50,$F$14:$F$77)),$F$14:$F$77,0))

which must be confirmed with control+shift+enter, not just with enter.
 
T

Tim

Thank You !

It functions. I try to do smth simmilar. but didn't confirm it with
ctrl+shift +enter so that's why I got confusing results.
 
Top