vba SumProduct Multiple Condition

I have an error on doing the sumproduct function on the vba.
It should be sheet1(cont no) = sheet2(cont no) & sheet1(amount) = sheet2(amount)
then copy the sheet2 info into sheet3.
But why it will copy all info into sheet3 below is my coding.


Sheet 1
no Cont no amount
a 111 10
b 333 10
c 222 20
d 444 20
e 555 20
f 222 10

Sheet 2

no Cont no amount
a 111 20
b 333 20
c 333 10
d 444 20
e 555 20
f 222 10

sheet 3
no Cont no amount
a 111 20
b 333 20

Please Login or Register  to view this content.

I would be better if you uploaded a workbook.