Sumproduct Vlookup Formula?

[restrada]

Dear People:
Please Help.

In sheet 1 I have a product number which equals 200.

In sheet 2 I also have the the product number, follow by gl, & amount.
Product number 200 has five different GL accounts. I need to tell sheet 1 to add the GL accounts (5) for product number 200. I attached the file. I hope this makes sense.

Not sure what kind of formula to use.

[NBVC]

You mean?

=SUMIF(Sheet1!C3:C7,A2,Sheet1!D3:D7)