Forum Discussion

Copper Contributor

Feb 23, 2023

Solved

How to match phrases found in text?

The goal is to use a named range of the keywords/phrases to flag sentences in column A that have any of them in column B. I have not had luck with SEARCH or MATCH and would rather not use a macro or...

Formulas and Functions

Detlef_Lewin
Feb 23, 2023
DrPepperFreak
SEARCH() is the way to go.
=SUM(--ISNUMBER(SEARCH(" "&$E$2:$E$5&" "," "&A2&" ")))=0

Detlef_Lewin

Silver Contributor

Feb 23, 2023

DrPepperFreak

SEARCH() is the way to go.

=SUM(--ISNUMBER(SEARCH(" "&$E$2:$E$5&" "," "&A2&" ")))=0