IF and formula NOT COMPLETE

[Wanna Learn]

Hello
Excel 2003 Scenario
I have 2 reports
This is what I ‘m trying to do

IF cell C60 = C78 in the second report AND if cell J60 = J78 in the second
report then AA78 from the second report

THis is what I have but don’t know how to finish the formula
=IF(C60=[SalesOrderDec909.xls]December09!$C$78,[SalesOrderDec909.xls]December09!$AA$78)
thanks

 

[FrankWood]

Try this and see if it does what you are looking for.

=IF(C60=[SalesOrderDec909.xls]December09!$C$78,IF(J60=[SalesOrderDec909.xls]December09!$AA$78,[SalesOrderDec909.xls]December09!$AA$78,"C60
is equal but J60 is Not equal"),"C60 is Not Equal")

Hope it helps,

Frank

 

[Eduardo]

Hi,
If you are looking for both conditions to be met use

=IF(and(C60=[SalesOrderDec909.xls]December09!$C$78,J60=[SalesOrderDec909.xls]December09!$J$78),[SalesOrderDec909.xls]December09!$AA$78,"")

I add the variable "" to leave blank if the conditon is not met