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:

List	Phrase	Matched words
break	hot tub forest break	break, forest
cabin	log cabin	cabin
cottage	cottage break	cottage, break
forest	forest hot tub holiday	forest

<tbody>
</tbody>

 

[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