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!

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
>
>