conditional multiplication

[jsm250]

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

[TMS]

Use VLOOKUP to get the relevant cost and multiply by the quantity.

[jsm250]

Thank you. it works

[TMS]

Needs to refer to two columns to get the second one.

Please Login or Register  to view this content.

[jsm250]

Awesome, thank you

[TMS]

And you need to make the range absolute.

Please Login or Register  to view this content.

[TMS]

You're welcome.



If you are satisfied with the solution(s) provided, please mark your thread as Solved.


New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

Or you can use this way:

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save


You may also want to consider thanking those people who helped you by clicking on the little star at the bottom left of their reply to your question.

[jsm250]

Got it, you saved my day!