You could also do this with a non CSE formula

=IF(SUMPRODUCT(1-ISERR(SEARCH(applications!A$2:A$8,A2))),LOOKUP(2^1 5,FIND(applications!A$2:A$8,A2),applications!A$2:A $8),"")

"Max" wrote:

Glad it helped, Mary-Lou.
Thanks for the feedback
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"MLK" wrote in message
...
Thanks Max! You are the best! This works perfectly. I have struggled
for
days on this.

Much appreciated.

Thanks again, Mary-Lou