How to find the value of Column A on the first instance of Column B > Column C
Given the below table
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