How to populate the Item Subtotal (located in Table 1) with a VLOOKUP to obtain the product of the quantity and the unit price The answer for the first subtotal is 20 56 I just need help on what function is needed to get that number These are two different tables on two different sheets in excel Order ID Order Date Ship Date Ship Mode Customer ID Product ID Quantity Item Subtotal Discount Item Subtotal Less Discount Tax Item Total CA 2011 103800 1 4 2011 1 8 2011 Standard Class DP 13000 OFF PA 10000174 2 0 2 CA 2011 112326 1 5 2011 1 9 2011 Standard Class PO 19195 OFF BI 10004094 2 0 8 CA 2011 112326 1 5 2011 1 9 2011 Standard Class PO 19195 OFF LA 10003223 3 0 2 CA 2011 112326 1 5 2011 1 9 2011 Standard Class PO 19195 OFF ST 10002743 3 0 2 CA 2011 141817 1 6 2011 1 13 2011 Standard Class MB 18085 OFF AR 10003478 3 0 2 CA 2011 106054 1 7 2011 1 8 2011 First Class JO 15145 OFF AR 10002399 3 0 Product ID Category Sub Category Product Name Unit Cost Unit Price FUR BO 10000112 Furniture Orange Blue 104 78 130 98 FUR BO 10000330 Furniture banana red 104 04 120 98 FUR BO 10000362 Furniture apple teal 131 65 170 98 FUR BO 10000468 Furniture Fruitcake orange 40 81 48 58 FUR BO 10000711 Furniture Lion purple 51 82 70 98 FUR BO 10000780 Furniture free green 168 82 200 98 FUR BO 10001337 Furniture Tiger blue 108 88 120 98

Question

How to populate the Item Subtotal (located in Table 1) with a VLOOKUP to obtain the product of the quantity and the unit price  The answer for the first subtotal is 20 56 I just need help on what function is needed to get that number  These are two different tables on two different sheets in excel  Order ID Order Date Ship Date Ship Mode Customer ID Product ID Quantity Item Subtotal Discount Item Subtotal Less Discount Tax Item Total CA 2011 103800 1 4 2011 1 8 2011 Standard Class DP 13000 OFF PA 10000174 2 0 2 CA 2011 112326 1 5 2011 1 9 2011 Standard Class PO 19195 OFF BI 10004094 2 0 8 CA 2011 112326 1 5 2011 1 9 2011 Standard Class PO 19195 OFF LA 10003223 3 0 2 CA 2011 112326 1 5 2011 1 9 2011 Standard Class PO 19195 OFF ST 10002743 3 0 2 CA 2011 141817 1 6 2011 1 13 2011 Standard Class MB 18085 OFF AR 10003478 3 0 2 CA 2011 106054 1 7 2011 1 8 2011 First Class JO 15145 OFF AR 10002399 3 0 Product ID Category Sub Category Product Name Unit Cost Unit Price FUR BO 10000112 Furniture Orange Blue 104 78 130 98 FUR BO 10000330 Furniture banana red 104 04 120 98 FUR BO 10000362 Furniture apple teal 131 65 170 98 FUR BO 10000468 Furniture Fruitcake orange 40 81 48 58 FUR BO 10000711 Furniture Lion purple 51 82 70 98 FUR BO 10000780 Furniture free green 168 82 200 98 FUR BO 10001337 Furniture Tiger blue 108 88 120 98

SolutionInn · Accepted Answer

The Answer is in the image, click to view ...

Order ID	Order Date	Ship Date	Ship Mode	Customer ID	Product ID	Quantity	Item Subtotal	Discount	Item Subtotal Less Discount	Tax	Item Total
CA-2011-103800	1/4/2011	1/8/2011	Standard Class	DP-13000	OFF-PA-10000174	2		0.2
CA-2011-112326	1/5/2011	1/9/2011	Standard Class	PO-19195	OFF-BI-10004094	2		0.8
CA-2011-112326	1/5/2011	1/9/2011	Standard Class	PO-19195	OFF-LA-10003223	3		0.2
CA-2011-112326	1/5/2011	1/9/2011	Standard Class	PO-19195	OFF-ST-10002743	3		0.2
CA-2011-141817	1/6/2011	1/13/2011	Standard Class	MB-18085	OFF-AR-10003478	3		0.2
CA-2011-106054	1/7/2011	1/8/2011	First Class	JO-15145	OFF-AR-10002399	3		0

Product ID	Category	Sub-Category	Product Name	Unit Cost	Unit Price
FUR-BO-10000112	Furniture	Orange	Blue	104.78	130.98
FUR-BO-10000330	Furniture	banana	red	104.04	120.98
FUR-BO-10000362	Furniture	apple	teal	131.65	170.98
FUR-BO-10000468	Furniture	Fruitcake	orange	40.81	48.58
FUR-BO-10000711	Furniture	Lion	purple	51.82	70.98
FUR-BO-10000780	Furniture	free	green	168.82	200.98
FUR-BO-10001337	Furniture	Tiger	blue	108.88	120.98

Question: How to populate the Item Subtotal (located in Table 1) with a VLOOKUP to obtain the product of the quantity and the unit price. The

Step by Step Solution

Students Have Also Explored These Related Databases Questions!