Hi Clay,

Am Fri, 24 Aug 2012 07:16:24 +0000 schrieb clay8:

b1 is clarice Leonie lee

c1 is clarice_lee @abc.com (without space)

d1 is Yes

OR
b1 is clarice Leonie lee

c1 is Carry_lee @abc.com (without space)
d1 is no

try:
=IF(ISNUMBER(FIND(LEFT(C1,FIND("_",C1)-1),B1)+FIND(MID(C1,FIND("_",C1)+1,FIND("@",C1)-FIND("_",C1)-1),B1)),"yes","no")


Regards
Claus Busch
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2