samilynn
Board Regular
- Joined
- Jun 24, 2003
- Messages
- 192
- Office Version
- 2016
- Platform
- Windows
Am I overthinking this? It "feels" like it should be very simple, but I'm having a hard time wrapping my brain around it:
In one tab of a workbook, I have a list of products and their respective price. In a different tab, I enter a customer, the product number, and a qty they are purchasing. I need to create a formula that tells me the order value of just the products they ordered. I know I can do it with a combination of vlookups in other columns, but can I just use one formula to get the total, without creating other columns?
I'm showing samples of the two tables below. Thank you so much for your help!!
Samantha
This is the sheet with the "supporting" product and price list:
This is the sheet where I create the order:
In one tab of a workbook, I have a list of products and their respective price. In a different tab, I enter a customer, the product number, and a qty they are purchasing. I need to create a formula that tells me the order value of just the products they ordered. I know I can do it with a combination of vlookups in other columns, but can I just use one formula to get the total, without creating other columns?
I'm showing samples of the two tables below. Thank you so much for your help!!
Samantha
This is the sheet with the "supporting" product and price list:
ITEM | BOX QTY | PRICE |
A1123 | 10 | $8.00 |
A1124 | 5 | $12.50 |
A1125 | 50 | $3.99 |
A1126 | 25 | $1.45 |
This is the sheet where I create the order:
ITEM ORDERED | QTY ORDERED | TOTAL ORDER VALUE |
A1123 | 100 | $1,525.00 |
A1126 | 500 | |