How can I do this in excel?

[burgonyapure]

I can't describe my problem any better:

if (sheet1!A1 == sheet2!A1 && sheet1!A2 == sheet2!A2) {
sheet2!A10=sheet1!A3;
}

If a cell equals to another cell on another sheet, then a given cell should have the value of a cell from another sheet.

 

[steve the fish]

What if it doesnt?

 

[burgonyapure]

What if it doesnt?

Write 0

 

[steve the fish]

Something like this in the 'given cell'

=IF(AND(Sheet1!A1=Sheet2!A1,Sheet1!A2=Sheet2!A2),Sheet2!A3,0)