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.
regexextract
? If that does what I think it does, doesA1
have a regex pattern or is "sites" your pattern?REGEXEXTRACT
will extract "needle" from "This is a needle of choice" if used:=REGEXEXTRACT("This is a needle of choice."; ".e{2}dle")