Hi Tricia,

Am Thu, 13 Feb 2014 08:28:13 -0800 (PST) schrieb Tricia Griffiths:

Account A B Value
XXX 1M 12M 3
FFF 1M <12M 1
CCC 1M <12M 1
MMM <1M 12M 4
TTT <1M <12M 2
DDD 1M <12M 1
KKK 1M 12M 3
PPP <1M <12M 2

try:
=(B2&C2="1M<12M")+(B2&C2="<1M<12M")*2+(B2&C2="1M 12M")*3+(B2&C2="<1M12M")*4


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