Searching word occurrence within a column (and reporting it)

Hi All,

Just found this forum thru Google and found it really useful.
I'm hoping that you can help me with this problem I'm having in Excel 2003.

I'm attaching the excel file that I'm doing in this post.

How do I make it so that a function can check column A for any occurrence of any of the words listed in column E and reports it in column B respectively as true or false

I have tried to use

Please Login or Register  to view this content.

This works fine with just one keyword, but I'm having difficulties using it to search several keywords as I can't use

Please Login or Register  to view this content.

in the formula above.

Any help or pointer would be much appreciated.
Thank you all in advance.

Originally Posted by memel

How do I make it so that a function can check column A for any occurrence of any of the words listed in column E and reports it in column B respectively as true or false

Using your example file:

Please Login or Register  to view this content.

or

Please Login or Register  to view this content.