Lookups to check if a column contains a value from a table

Good Day.

I have two sets of data. One is a list, the other are values I need to compare to. In column B, I have a string such as "QW_ERTY_ASDF_ZXC" I need to see if these values contain, in any part of the cell a value from my 2nd set of data, which could contain any random chunk of the first string. Example: my 2nd table might have a cell that reads "DF_Z" or "QW_ERT", in which case the lookup would be true.

I need to make this work, and unfortunately I was given very messy data, but I think it can be done, I just don't know how.

Thanks for your help.