On Sat, 4 Jun 2005 16:47:01 -0700, "Amanda Guenthner"
wrote:

Is there a way to combine the logic you provided to do the wildcard search
for the string embedded in my initial IF statement? No worries if this is
really complicated.

You can combine things using OR constructs. (Adding things the way I do below
is the equivalent of OR).

However, since I don't know all of the possibilities, you may have to modify my
suggestion. It should give you some ideas, though:

=IF(N10&O10="","",
IF(COUNTIF(N10,"*CCT*")+
COUNTIF(N10,"*Customer Contact Transformation*")+
COUNTIF(O10,Customer Contact Transformation),
"CCT","CCO"))



--ron