Find the first time a value is listed in a row

[erniepoe]

Hey there,

I have some formulas going in five straight columns, and the results from W1:AA1 result in no, no, yes, yes, yes, which correspond to 1,2,3,4,5 (the column titles, which will never change, it will always be 1-5).


I'm trying to find a formula that will identify that the first occurrence of the yes happens in cell C1, and then return the corresponding value (in this case, 3).

I'm trying the index match route but just not figuring it out. Anybody have a solution? Thanks so much!

 

[AhoyNC]

Something like this?

Excel Workbook
	C	D	V	W	X	Y	Z	AA
1	3			no	no	yes	yes	yes
Sheet