Index/Return cell references from table array based on "Yes"/"No" response

[tatendamark]

I would like a formula that returns the column and row name, based on "Yes"/"No" response in a table array. Please see below. Basically, I would like a formula that automatically returns the values in the last row below (excel attached):

SCENARIO	A	B	C	D	E
1	Yes	No	No	No	No
2	No	No	No	Yes	No
3	No	Yes	Yes	No	No
4	No	No	No	No	Yes
5	No	No	No	No	No
	Return the following scenarios, based on above "Yes" response
Scenarios	1A	2D	3B	3C	4E