I have a range of cells that contain the quantity of a specific product

example:
C
1 Product A 3
2 Product B 7
3 Product C 2
....

so my range is C1:C3
now i need to calculate the total weigh of all the products
i have the list of products defined as Products, in table form
i can find the weight of a specific product using vlookup
=VLOOKUP(C1,Products,4,false)

the total weight of Product 1 would be
=C1 * VLOOKUP(C1,Products,4,false)


now i would like to use SUMPRODUCT to get the sum of the # of product X *
the weight of product X

any suggestions?