Check cell for multiple strings and return specific values

Question

I'm trying to create a Google Sheet formula that searches for a word in a longer string and returns a specific value based on the string being searched.

I can achieve this in Excel but I need this to work in Google Sheets.

Below is an example of what I'm trying to achieve:

The "Sort" column is retrieving the value based on checking if the word in column "C" exists in column "A".

I've tried using wildcard search but this isn't working for me in Google Sheets, and other examples I've seen online don't seem to allow me to return multiple values.

Any help would be much appreciated.

Answer 1

This formula may fit you:

=IFERROR(REGEXEXTRACT(A1,JOIN("|",FILTER(C:C,C:C<>""))),"none")

Here're some useful links:

REGEXEXTRACT

JOIN

FILTER