Thank you very much Tom for prompt reply. I wonder if I am doing it
wrong or was unable to explain my problem correctly. I changed the code
as you mentioned, however it still doesn't work...Let me explain my
problem again:

worksheet1:

ColumnA

I want to search this string and see if it has any word that belongs to
columnA in worksheet2


Worksheet2:

ColumnA ColumnB

search return
word this
manager value
temp in
template other
other worksheet


As we see, word "Search" in column A, worksheet2 is in the given string
in worksheet1...so I need word "return" from column B of worksheet2 in
column B of worksheet1...if columnA, worksheet2 doesn't have any of the
words from that string, then return "not found"

Please let me know if you need more information.

Again I appreciate your prompt response.

Thanks.