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...