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.