One way would be to use a helper column. Try the following (formulas
need to be confirmed with CONTROL+SHIFT+ENTER , not just ENTER)...

Helper column:

AD1:

=INDEX({555,666,777},MATCH(1,(COUNTIF(AA:AA,A1:A3) 0)*(COUNTIF(AB:AB,B1)
0),0))

AD2:

=INDEX({888,999,0},MATCH(1,(COUNTIF(AA:AA,A1:A3)0 )*(COUNTIF(AB:AB,B2)0)
,0))

AD3:

=INDEX({111,222,333},MATCH(1,(COUNTIF(AA:AA,A1:A3) 0)*(COUNTIF(AB:AB,B3)
0),0))

AD4:

=INDEX({1212,2323,4545},MATCH(1,(COUNTIF(AA:AA,A1: A3)0)*(COUNTIF(AB:AB,B
4)0),0))

This column can be hidden, if so desired. Alternatively, you can choose
'White' as your font color to hide these cells.

Desired result:

AE1:

=INDEX(AD:AD,MATCH(TRUE,AD1:AD4=0,0))

Hope this helps!

In article ,
"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