What's the order of priority here Alex? Or are your test results mutually
exclusive?

What if values in column AA match A1 and A2 and/or A3?
What if values in AB = B1 and/or B2 and/or B3?

If there is no chance of multiple tests being true, you can use something
like this

=(AND(COUNTIF(A:A,A1)0,COUNTIF(AB:AB,B1)0) *555) +
(AND(COUNTIF(A:A,A2)0,COUNTIF(AB:AB,B1)0) *666) +
---finish your other 10 conditions with the same order


"ALex" wrote:

What type of formula would respond to the following conditions 12 (excel
seems to only permit up to 7...is it possible to get around that?):

IF Any Cell in Column AA= A1 and Any Cell in Column AB =B1 then C1=555
IF Any Cell in Column AA= A2 and Any Cell Column AB =B1 then C1=666
IF Any Cell in Column AA= A3 and Any Cell Column AB =B1 then C1=777

IF Any Cell in Column AA= A1 and Any Cell in Column AB =B2 then C1=888
IF Any Cell in Column AA= A2 and Any Cell in Column AB =B2 then C1=999
IF Any Cell in Column AA= A3 and Any Cell Column AB =B2 then C1=000

IF Any Cell in Column AA= A1 and Any Cell in Column AB =B3 then C1=111
IF Any Cell in Column AA= A2 and Any Cell in Column AB =B3 then C1=222
IF Any Cell in Column AA= A3 and Any Cell Column AB =B3 then C1=333

IF Any Cell in Column AA= A1 and Any Cell in Column AB =B4 then C1=1212
IF Any Cell in Column AA= A2 and Any Cell in Column AB =B4 then C1=2323
IF Any Cell in Column AA= A3 and Any Cell Column AB =B4 then C1=4545

help me please?

Alex