Return the value (or column #) of the first instance in a row that meets certain criteria

[dmarsh]

Hello,

I'm looking for a way to return the value (or the column #) of the first instance in a row that meets certain criteria. For example:


Let's assume that I want to find the first instance in row 3 with a value greater than 15. I would like a formula that would either return the value of 20 (which is in Col C) or a column reference of 3 (related to Col C).

Col B Col C Col D Col E Col F

Row 3 5 20 15 25 22

Thanks in advance for your help!
Danny

 

[Canapone]

Hi,

	A	B	C	D	E	F
1
2	4	3	15	20	25	22
3	20

<tbody>
</tbody>

Foglio2​

Worksheet Formulas Cell Formula A2 =IFERROR(MATCH(TRUE,INDEX((B2:F2>15),),0),"")+1 A3 =IFERROR(INDEX(B2:O2,MATCH(TRUE,INDEX((B2:F2>15),),0)),"") <tbody> </tbody>

<tbody>
</tbody>

Not sure if you need +1 in the first formula.

Hope it helps

 

[dmarsh]

Thank you! Both worked exactly as I hoped they would. Thanks again!

 

[Canapone]

Hi,

thanks for providing feedback.