Keyword search, several keywords

[Doman]

I have a column with a keyword at each row, there are several keywords
Now I want to check, row for row, if any of these keywords occurs i
another column. I want this check to be done by using only one colum
for the calculations.

Ex:
KEYWORD
test
alpha
house
bike

COLUMN A | COLUMN
Row tow bow | FALSE
Pest test best | TRUE
Alpha beta gamma | TRUE
xor or and | FALSE

Thanks in advance

 

[Guest]

One way ..

Assuming keywords will be entered within F1:F10

With source data running in A1 down,
In B1, copied down:
=SUMPRODUCT(ISNUMBER(SEARCH($F$1:$F$10,A1))*($F$1:$F$10<>""))>0
would return the required results

Replace SEARCH with FIND if you need it to be case sensitive.
SEARCH is not case sensitive.