Hi,

I reviewed this post http://www.excelforum.com/excel-gene...-keywords.html
My request is slightly different.
I have a text string that sometimes has multiple names in it.
In the keyword list I would have all the names.
I would like to search the text string and return the first name it finds that matches any name in the keyword list.
It seems the above link does the opposite, it displays the names according to the order from the keyword list.

I played around with the formula but couldnt get it to do what i want.
Appreciate your assistance.