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