Finding parts of a text from the full table of possible matches - FIND? Array?

Hi,

I am running keyword campaigns google/amazon, but lately I am seeing low traffic. I am guessing someone screw something up – put the wrong keywords into the negative and that is why they are not shown.

I want to crosscheck the POSITIVE keywords against the negative ones. For exact phrases it is simple – just use the VLOOKUP function and you are done.
But I also have phrase match, where the word or phrase in a negative phrase match column can just be a part of a positive phrase. For example, if a positive phrase is »white light weight sweater« and negative broad match is »light« the positive keyword should be flagged.
I know there might be a problem to see if the keyword has multiple matches but I do not care about that, because I really need to know if there are none. So, 1 or more it will lead to an inspection.
I thought this can be done with FIND function, but I do not know how to run find on a full table of possible matches….

In the attachment I am sending you the example file.

Thank you for the help!
Andraz

forgot to add the attachment