How to find the value of Column A on the first instance of Column B > Column C

Given the below table

enter image description here

I have Column A as a unique key value, I am looking to return the first key value where B < C

In this case the first instance is A = 3 Where B = 4 and C = 5

Can someone help me understand the LOOKUP formula to return the value 3?


Solution 1:

You can achieve this with the below:

=INDEX(A1:A4,MIN(IF(C1:C4>B1:B4,ROW(A1:A4),100000)),1)

Enter this as an array formula by pressing Ctl + Shift + Enter to enter it

enter image description here