On sheet 1, I have the "product" and "units sold". On sheet 2 I have "product" and "product cost". For every row on sheet 1, I need to calculate "cost of goods" by comparing the product on sheet 1 to product on sheet 2 and matching the price of the product and multiplying with the 'units sold'. Please see table below. Highly appreciate any help offered to solve this conditional multiplication. Thanks

Sheet 1
"Product" "Units Sold" "Cost of Goods"
Item 1 ----- 500
Item 2 ----- 409
Item 1 ----- 678
Item 4 ----- 879
Item 2 ----- 98
Item 6 ----- 23
Item 9 ----- 665
Item 8 ----- 76
Item 1 ----- 90
Item 4 ----- 532

Sheet 2
Product Product Cost
Item 1 ----- $4.00
Item 2 ----- $5.00
Item 3 ----- $3.00
Item 4 ----- $2.00
Item 5 ----- $1.00
Item 6 ----- $8.00
Item 7 ----- $6.00
Item 8 ----- $9.00
Item 9 ----- $34.00
Item 10 ----- $56.00