How to classify strings according to the words they contain?

Question

Google Sheets

There are two tables shown in the example : the "Data" and "Keywords" tabs.
Text phrases in the Data tab (column B) must be assigned a category from the Keywords tab (column B) if they contain a certain sequence of characters from the set in the Keywords tab (column A).
An example of the expected result on the "Result" tab.

Answer 1

Start with sample data, and preferably one that you will work with. So far, nothing is clear in your question. In addition to REGMATCH () and FILTER () may come in handy