Keyword search, several keywords
 

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

Keyword search, several keywords
 

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.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Doman" wrote:
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