IF statement help

[thewiseguy]

Hi everyone,

I am trying to create a simple formula which would work like this:

IF A1, B1 and C1 = Sheet2! A1,Sheet2! B1 and Sheet2! C1 THEN Sheet2! D1


Can anyone help? Thanks in advance!


-m

 

[Jonmo1]

=IF(AND(A1=Sheet2!A1,B1=Sheet2!B1,C1=Sheet2!C1),Sheet2!D1,"")

 

[Aladin Akyurek]

Hi everyone,

I am trying to create a simple formula which would work like this:

IF A1, B1 and C1 = Sheet2! A1,Sheet2! B1 and Sheet2! C1 THEN Sheet2! D1


Can anyone help? Thanks in advance!


-m

=IF((A1=Sheet2!A1)*(B1=Sheet2!B1)*(C1=Sheet2!C1),Sheet2!D1,"")