IF statement/formula help across multiple columns :-)

[Yecart77]

Hello Excel Experts,
Needing some guidance on how to go about an if statement/formula for this scenario. I'm not sure if an IF statement is the best way or if there is a better way to do it in excel.
This is part of an accounting general journal generator I am building to automate corrections that can uploaded into financial system as the journal description.
In the screenshot below:
Cells A1:E1 have the elements that will be corrected such as General Ledger Code, Profit Centre, etc expressed as AAA, BBB,etc for simplicity.
Cells A2:E6 contain numerical values, expressed as an x, again for simplicity. If that element is correct the cell will be blank.
Cells C2:C6 contain the comments I want the formula to return.
E.g. Row 3 has an error in Element AAA and CCC, so I would like the formula to return the text 'Correct-AAA-CCC' in F3.
I hope I have explained that with clarity. Any insights on where to start are much appreciated.
Cheers,
Tracey

 

[etaf]

as you have later versions of Excel - 365
how about using text join

I suspect it can be done as a full array - and not require copying down, but this is my first take ,

Book4
	A	B	C	D	E	F
1	AAA	BBB	CCC	DDD	EEE	Journal Output
2
3	x					Correct - AAA
4
5	x		x			Correct - AAA - CCC
6	x	x	x	x		Correct - AAA - BBB - CCC - DDD
Sheet1

Cell Formulas
Range	Formula
F2:F6	F2	=IF(COUNTA(A2:E2),"Correct - "&TEXTJOIN(" - ",,IF(A2:E2="X",$A$1:$E$1,"")),"")

 

[Yecart77]

Hi Etaf,
Thank you so much, that works perfectly in 365. Could I please trouble you for what I would use in Excel 2016 where TEXTJOIN isn't available. I played around with CONCAT but could get the hypen as a separator in the same place e.g. Correct-AAA-BBB. Cheers, Tracey

 

[etaf]

sorry, i dont know off the top of my head, i will try and research , long time since i have used 2016 , also not sure i ever needed to do this sort of thing
hopefully some other member will see the thread and know

 

[Fluff]

How about

=IF(COUNTA(A2:E2),"Correct"&IF(A2="x"," - "&$A$1,"")&IF(B2="x"," - "&$B$1,"")&IF(C2="x"," - "&$C$1,"")&IF(D2="x"," - "&$D$1,"")&IF(E2="x"," - "&$E$1,""),"")