|Here is a SUMPRODUCT() function that uses a Defined Name list that might meet your requirements.|
With your target string in column A
In Column C create a Keyword List
Now we give our keyword list a Defined Name
First select C1 thru C11
On the ribbon select the Formula Tab
Select Define Name
In the Name box give it a name like MyList
Leave the Scope as Workbook
Check the Refers To box and make sure it contains your range of cells,
Next, in cell B1 enter the formula:
If any of your Keywords appear in cell A1 you will get a TRUE
If none of your Keywords appear in cell A1 you will get a FALSE
Drag down as many rows as necessary.
Your Keyword list can be as long as you need, just make sure you have
all the cells in the Defined Name.
See how that works for you.