Google-sheets – Google Sheets formula for “if contains” from range

filterformulasgoogle sheetsgoogle-sheets-arrayformulagoogle-sheets-query

I try to figure out how to get a value based on "if some word is in a range".
So formulas from (Google Sheets formula for "if contains") works:

=IF(ISTEXT(REGEXEXTRACT( A1, "sites")), 1,0)

=IF(regexmatch( A1, "sites"), 1, 0)

but instead of a specific word like here i.e. is "site", I would like to get True, False based on condition if any word from range is in a string. Also, it would be nice if it automatically expands the range in the formula, if I'll add some new word.

Best Answer

for "true / false" part:

=IF(ISTEXT(REGEXEXTRACT(A1;"sites"));"True";"False")

for "more words crossreferenced with another sheet" part:

=IF(ISTEXT(FILTER({'sheet1'!A1:A3};{'sheet1'!A1:A3}=A1));"True";"False")

Related Topic