Combine 2 IF formula return 2 different value

I have a list of such titles about 2000

A1: Titles
A2: 10 Facebook Marketing Ideas for Small Business
A3: 10 Fun Facts About Social Media
A4: 10 Fitness Tips for Health Life

And I have about 20 popular singular word from the above title that I want to use as tags for each title
B1: Popular Singular Words in The List of 2000 titles (there are 20 such words)
B2: Business
B3: Social
B4: Health
B5: Fitness
B6: Marketing
B7: Facebook


In C2 I want to return multiple values i.e Marketing, Business, Facebook these are the 3 tags assigned to the title in A2. Since I only have 20 popular words to tag, is there a way I can combine the below formula 20 times in single cell and return multiple values separated by comma maybe by using concatinate.

=IF((ISNUMBER(SEARCH(B2,A2))),B2,"")

Are you still using Excel 2007: if not, please update your profile with current version,

Thanks for reminding, just updated. I am using 2010

In C2 try this array formula. Use CTRL + SHIFT + Enter when confirming the formula. If done so correctly { } will be added around your formula automatically. Then drag the formula down.

Formula:

=TRIM(CONCAT(IF(ISERR(SEARCH($B$2:$B$7,$A2)),"",$B$2:$B$7&" ")))

Its not working

Attachment 794131

Cant see the attached image in your previous post. I changed CONCAT to an older version CONCATENATE function which should work on your excel version.
Again still an array formula so use CTRL + SHIFT + ENTER.

Formula:

=TRIM(CONCATENATE(IF(ISERR(SEARCH($B$2:$B$7,$A2)),"",$B$2:$B$7&" ")))

It returns the first value only, A2 has 3 words from col B. Business, Facebook, Marketing. I was looking for a formula/solution that return all 3 words in cell C2. Also when I drag the formula down the column it doesn't work, it returns empty.

Screenshot: https://i.ibb.co/dWbcH9n/excel.jpg

You are right 2010 is a bit outdated for this. I tried the first formula provided by @dosydos In excel at live.com and it worked. This is a great help for me it's going to save me a huge lot of time, I will be using this very frequently. Thanks a lot, guys! I love this forum. 珞