How to search a cell for numerous names?

[Jan_H]

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel

Hello,

I have want to search a cell if it contains one of multiple names from other cells.

I have a spreadsheet which contains -
Column A, which 100 rows containing different names.
Column B contains 400 rows of text

Now i want to check of each cell in column B to see if it contains any of the names from column A.

I hope this makes sense.

best regards,

Jan H.

 

[Jan_H]

Hello again,

I found a solution - thanks.

=IF(ISNUMBER(MATCH(MID(B2,7,FIND(" ",B2,8)-7),A:A,0)),"Found","")

Best...Jan