Copy cell, if content matches certain keywords in Google Sheets

[mvrht]

I need to copy the value of a cell if the contents contain a keyword from a list in a Sheet I have.

You can see an example and make a copy here
https://docs.google.com/spreadsheets/d/1Fmn6UtJ8QbRGsGYVgVcUpfg_kmCVk4MLGhNDBVtAxJk/edit?usp=sharing

So if the news story listed in "RSS News Feed" matches a keyword in "Alert Keywords", we copy the name of that news story to the Sheet "We have a match"

I did find a similar scenario that used the function below that would need editing, but as we are looking for keywords within text. Think we perhaps need an alternative function

 

[mvrht]

The possibly function formats

=INDEX(Sheet1!B:B,MATCH($A1,Sheet1!A:A,0))
= ArrayFormula(if(len(B2:B),iferror(vlookup(B2:B,'Price List'!A2:B,2,false),"Not found"),))