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 in
another column. I want this check to be done by using only one column
for the calculations.

Ex:
KEYWORDS
test
alpha
house
bike

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

Thanks in advance!


--
Doman
------------------------------------------------------------------------
Doman's Profile: http://www.excelforum.com/member.php...o&userid=36271
View this thread: http://www.excelforum.com/showthread...hreadid=564185