Search a text string to see if it contains a word from a defined list, return that word

Hi

A thread with a similar question was posted here:

http://www.excelforum.com/excel-gene...in-string.html

However, the output required by that OP was only whether or not the a word from the list was present in the text string or not. Can anyone tell me how I can also return the found word?

Thanks for considering,
Jacques

Thanks martindwilson! That's perfect!