Try...
=IF(COUNTIF(AA:AA,A1)*COUNTIF(AB:AB,B1),555,IF(COU NTIF(AA:AA,A2)*COUNTIF(
AB:AB,B1),666,IF(COUNTIF(AA:AA,A1)*COUNTIF(AB:AB,B 2),444,IF(COUNTIF(AA:AA
,A2)*COUNTIF(AB:AB,B2),777,""))))
Hope this helps!
In article ,
"ALex" wrote:
What type of folmula would respond to the following conditions:
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= A1 and Any Cell in Column AB =B2 then C1=444
IF Any Cell in Column AA= A2 and Any Cell in Column AB =B2 then C1=777
help me please?
Alex
|