hello,

i was trying to find a formula that returns 1 or 0 (or true / false), if cell A1 contains any word from array B1 to B20.

i found a function =OR(NOT(ISERR(SEARCH(B1;A1)));NOT(ISERR(SEARCH(B2;A1)));NOT(ISERR(SEARCH(B3;A1))))
but it only works for B1 - B8, than the formula is too long.

i also made a function that finds out if A1 is exactly the same as B1, B2, B3,... but that it is not what i need, i need to find out if the string in A1 contains any of the words

can you pls help me?