Trying to output "True" if a cell contains a string listed in a range. See screenshot. This is a simplidied version of an old question I posted here

CodePudding user response：

I believe your goal is as follows.

• For example, when a cell "D3" is checked in your showing image, you want to search using the values of all cells "C3:C".

In this case, how about the following sample formula?

Sample formula:

=ARRAYFORMULA(IF(D3:D<>"",REGEXMATCH(D3:D,TEXTJOIN("|",TRUE,C3:C)),""))

• In this formula, the values of "C3:C" are used as the regex.

Result:

Reference: