first value > 0

[Ted Metro]

If I have a list of numbers in b2:G2 and months of the year above in b1:g1
what formula can I enter that will display the first month in which a value
is greater than 10.

like so --

jan feb mar apr ...
apples 10 8 12 15

First month greater than 10 is march.

Ted

 

[N Harkawat]

=index(b$1:g$1,match(true,b2:g2>10,0))
array entered (ctrl+shift+enter)