I'm no sheet wiz. What I'm looking for is a formula that can make this happen.

I have a list of prohibited terms in Column C to E. Cell B1 has a 200-character paragraph that I need to audit. What I'm looking for is for Cell A1 to list all the words found in that paragraph that matches any prohibited term in Column C to E.

Again, I'm no wiz. Tried looking online for solutions but I can't seem to find something close to what I'm looking for.

CodePudding user response：

You can try with this formula that filters depending in if the words are found:

=FILTER (FLATTEN (C:E),FLATTEN(C:E)<>"",REGEXMATCH(B1,"\b(?i)"&FLATTEN(C:E)&"\b"))

\b allows to find complete words, and (?i) to make it case insensitive