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. May be easier to copy information into excel with 2 different tabs. I am looking for the function to get the number above.

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