Return answer if yes or no in multiple cells

[surkdidat]

Hi

I am putting a formula in column A, based on the "Yes" or "No" answer in columns, I, J, K, L, M and N

So, I need : whatever column contains "Yes" in that row, to list the value in row 1

	Column A	Column I (Return AAA)	Column J (Return BBB)	Column K (Return CCC)	Column L (Return DDD)	Column M (Return EEE)
Row 1	AAA	Yes	No	No	No	No
Row 2	CCC DDD EEE	No	No	Yes	Yes	Yes
Row 3	AAA DDD	Yes	No	No	Yes	No

 

[FormR]

You could give this a try:

Book3
	A	B	C	D	E	F
1		AAA	BBB	CCC	DDD	EEE
2	AAA	Yes
3	CCC DDD EEE			Yes	Yes	Yes
4	AAA DDD	Yes			Yes
Sheet1

Cell Formulas
Range	Formula
A2:A4	A2	=TEXTJOIN(" ",TRUE,IF(B2:F2="Yes",$B$1:$F$1,""))
Press CTRL+SHIFT+ENTER to enter array formulas surrounded with curly braces.

 

[surkdidat]

You could give this a try:

Book3
	A	B	C	D	E	F
1		AAA	BBB	CCC	DDD	EEE
2	AAA	Yes
3	CCC DDD EEE			Yes	Yes	Yes
4	AAA DDD	Yes			Yes
Sheet1

Cell Formulas
Range	Formula
A2:A4	A2	=TEXTJOIN(" ",TRUE,IF(B2:F2="Yes",$B$1:$F$1,""))
Press CTRL+SHIFT+ENTER to enter array formulas surrounded with curly braces.

superb - thanks!