Find array value within a string

I want to FIND if a value in a table occurs within a text string.

For example.... I have a number mulitple rows of random letters such as....

dfgrtvghj
utyhg
124BVWghjj

And my lookup table has the values

rtv
BVW

These values do exist in the example above in rows 1 and 3 but not in row 2.

So, for each row, how can I validate whether a value in my lookup table exisits within the random letters. (My lookup range is ver large so I cannot use nested FIND statements).

Thanks

Use 2 Helper columns, one for rtv one for BVW
Use FIND or SEARCH for each inidivual string you're looking for return either TRUE or FALSE
Copy the formula down the columns

So your output is like

rtv BVW
dfgrtvghj TRUE FALSE
utyhg FALSE FALSE
124BVWghjj FALSE TRUE

If we assume your strings are in Col A and your table of "keywords" is say D1:D2 then

B1: =ISNUMBER(LOOKUP(9.99E+307,SEARCH($D$1:$D$2,$A1)))
copied down

replace SEARCH with FIND if you require case sensitivity