INDEX, MATCH: I want to get the first cell address where value is >= 2

Hello All,

For a range of values (e.g. A2:E2), I want to get the first cell address where value is greater than or equal to 2.

I am able to use the formula "=INDEX($A1:$E1,MATCH(2,A3:E3,1))" which gives me the correct answer "B" for the 2nd row. But e.g. for 3rd row, the correct answer is also "B" but I get "C". I want to know how can I put condition ">=2" and not equal to 2?


A B C D E Result
1.434 2.016 2.825 4.393 6.916 A
1 3 2 1 1 C

Thanks so much.

Thanks so much XOR LX!! Now I understand how to use "Match" function for when I don't have sorted lists.

Supercool! I appreciate your help a lot!!