Hi-

I am trying to flag a record as being either €œCCO€� or €œCCT€�, where any
record with either of the following would be flagged as CCT (else would be
CCO):
1. Domain value is at least one of the following: "Customer Contact
Transformation (CCT/ACCS€�, €œCustomer Contact Transformation","Customer
Contact Transformation (Scale Play)"
OR
2. Campaign = "Customer Contact Transformation (CCT)"

I had used the following if statement:
=IF(N10&O10="","",IF(OR(N10="Customer Contact Transformation
(CCT/ACCS)",N10="Customer Contact Transformation",N10="Customer Contact
Transformation (Scale Play)",O10="Customer Contact Transformation
(CCT)"),("CCT"),("CCO")))

The problem with this, however, is that the Domain field can have multiple
values (i.e. can have one of the CCT related values in #1 plus another
unrelated value). This statement is only looking for exact matches; hence I
am not flagging all those that I need to because I want it to = CCT if any
one of the Domain values contains CCT or the Campaign value contains CCT.

Is there a way to structure IF statements to look for records that contain
certain text (i.e. like in SQL how you can do ïƒ* is like €˜%CCT%)? Perhaps I
need to do something more complex than an IF statement€¦not sure what this
would be though.

I would really appreciate any help with this. Thanks in advance.

Amanda