I am trying to find a way to search a list (“Search Terms” in screenshot) and see if that text string contains both word 1 (D2) and word 2 (E2). The order in which “word 1” or “word 2” in the search doesn’t matter. I would like to know if they are both present in the “search term”.

I found this formula:
=SUMPRODUCT(--ISNUMBER(SEARCH(things,B5)))>0

This very close to what I need. However, it designed to search 1 list.

Is there a way to create an "and" function in the formula above? So that the formula searches both “word 1" and “word 2" lists and returns true if both words are present in the keyword. Returns a false value if 1 or zero of the 2 words is present in the search term.

Cell Contains Many Things.png