Did you try my original suggestion? I can't tell if you're saying it
would work or not.

=IF(ISNUMBER(OR(FIND({"abc","def","ghi","jkl","mno "},D1,1))),D2,D1)


--
JBeaucaire
------------------------------------------------------------------------
JBeaucaire's Profile: http://www.thecodecage.com/forumz/member.php?userid=73
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=57649