Both of these worked! Thanks so much!!!

On Thursday, February 13, 2014 1:38:50 PM UTC-4, Claus Busch wrote:
Hi Tricia,



Am Thu, 13 Feb 2014 18:33:57 +0100 schrieb Claus Busch:



try:

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



or

=VLOOKUP(B2&C2,{"1M<12M",1;"<1M<12M",2;"1M12M", 3;"<1M12M",4},2,0)





Regards

Claus B.

--

Win XP PRof SP2 / Vista Ultimate SP2

Office 2003 SP2 /2007 Ultimate SP2