Formula looking up an Amt & Qty and multiplying them together

[excel?]

Need help to get a formula that will lookup a code to find a Quantity and an Amount and multiply them together.

I have the info below In Cols A & B and data in Rows 3-7 and 8-12. I want to look up a code like Whse and multiply the Quantity times the Rate.

Quantity
Whse.......3
Rcvng......2
Invty.......1
Shpng......2

Amount
Whse.......$250
Rcvng......$325
Invty.......$270
Shpng......$300

I appreciate any help you can provide. Thank you.

 

[Joe4]

Do a VLOOKUP to each table, and multiply those two values together, i.e.

=VLOOKUP(...) * VLOOKUP(...)

See here for more details on VLOOKUP, if you are not familiar with it: https://www.techonthenet.com/excel/formulas/vlookup.php

 

[excel?]

Thank you, very helpful

 

[Joe4]

You are welcome.