Text populated based on multiple cells

[djthery]

Hello,

Looking for some help on figuring out how to make column I populate text based on data entered into column J-L.

I would like Column I to populate UW, UWS, or None either by itself or in a combination based on which cells in Column J-L are marked with "x".

Any help is appreciated! I've been on the google for a while trying to find a formula that would work and haven't found anything yet.

 

[Fluff]

Hi & welcome to MrExcel.
Can you have more than one x, or no xs? If so what should happen?

 

[djthery]

Hi & welcome to MrExcel.
Can you have more than one x, or no xs? If so what should happen?

Thanks!

Yes, x could be present in both J and K and I would like it to display "UW, UWS". There would not be a scenario where x is not present at all in J-L.

 

[Fluff]

Ok, how about

=TEXTJOIN(", ",,IF(J2:L2="x",J1:L1,""))

 

[djthery]

Ok, how about

=TEXTJOIN(", ",,IF(J2:L2="x",J1:L1,""))

Thanks Fluff but for some reason it is showing the formula in the cell. I adjusted it so it would be the correct cells and even redid it in a different workbook but I am only getting the formula and not the result. I redid this in a new workbook and the result shows #VALUE!.

 

[Fluff]

it is showing the formula in the cell

Make sure that the cell is formatted as general & not text.

 

[djthery]

Make sure that the cell is formatted as general & not text.

Thanks that fixed the formula being in the cell but the return result is #VALUE!

 

[Fluff]

Do you have formulae in J3:L3?

 

[djthery]

Do you have formulae in J3:L3?

no, the formula you sent is the only one in the workbook.

 

[Fluff]

Do you have either the Unique function or the Sequence function?