Hello from Steved

{=SUMPRODUCT((Sheet1!C:C=B2),(Sheet1!D:D=$C$2))}

I am getting a #NUM!

The formula is in A2 in Sheet2.

The object is to Find the value in Col A:A Sheet1 and
copy it to Sheet2.

Thankyou.