Write several words in a cell conditionned to statements in several other cells

[SylvainFB]

Hello guys! I am currently doing a qualitative analysis of short comments. I have created a spreadsheet with comments as rows and categories (or 'codes') as columns; so that for the comment "I like ice cream and tea", I will tick the category "food" and "beveridge" ("ice cream" being included in the "food" category, and "tea" in "beveridge").

I am automatising the categorisation through keyword search, with the formula for the "food" column:
=(SUMPRODUCT(--ISNUMBER(SEARCH({"ice cream"};A1)))>0)
So that the cell returns TRUE when the keyword appears. It works well.

Now, I would like to create a column next to the comment column where the names of the categories would be written if an attached keyword appears in the comment. For instance, next to the comment "I like ice cream and tea", there would be a cell reading: "food - beveridge".

Does anyone have any idea how to do that? You would have my outmost gratitude and I'll send you some ice cream.
Have a good day!
Sylvain

 

[dnorm]

Where your results = food in A1 and beveridge =B1 ect: try using the formula '=CONCATENATE(A1,B1,ect...)' to display the result in a single cell if you want a dash in between words add =CONCATENATE(A1," - ",B1,ect...) however without an 'IF' formula this will always the dashes so you could end up with "Food - - -" as a result if you have that many variations in results.

 

[SylvainFB]

I will try and come back to you, thanks!

 

[SylvainFB]

Works like a charm, many thanks!

 

[dnorm]

Glad I could help!