Formula to lookup values from a list and return matched value

[chappers]

I need a formula to match words contained in a phrase (B) to values in a list (A1:A5) and copy the matched values into a cell (C) e.g:

[TABLE="width: 500"]
<tbody>[TR]
[TD]List[/TD]
[TD]Phrase[/TD]
[TD]Matched words[/TD]
[/TR]
[TR]
[TD]break[/TD]
[TD]hot tub forest break[/TD]
[TD]break, forest[/TD]
[/TR]
[TR]
[TD]cabin[/TD]
[TD]log cabin[/TD]
[TD]cabin[/TD]
[/TR]
[TR]
[TD]cottage[/TD]
[TD]cottage break[/TD]
[TD]cottage, break[/TD]
[/TR]
[TR]
[TD]forest[/TD]
[TD]forest hot tub holiday[/TD]
[TD]forest[/TD]
[/TR]
</tbody>[/TABLE]

 

[Special-K99]

if you want the results separated by a comma then use TEXTJOIN if you have it otherwise the solution would have to be VBA.
I have seen a formula to concatenate results with a comma but it was extremely complicated and looked like it related specifically to the problem in question.

 

[chappers]

Its for Google Sheets. Is there a formula just to match the first word from the list?

 

[sandy666]

[deleted]

edit: I c someone was faster and moved this thread