how to multiply the values pulled by vlookup to be able to calculate the total amount of products sold

[gburo]

I'm trying to find a solution of how to multiply the values that I managed to pull by Vlookup into invoice template. After selecting the product from the dropdown I get the remaining values in columns B:G by using VLOOKUP from a different table. What I'm trying to do now is to add a formula so when I change the QTY.sold in column D to 2 or 3 and columns E,F,G that are NET amount, VAT, and TOTAL will multiply by 2.

What I want to achieve is to select the product from the dropdown change the quantity sold and have all the rest calculated for me to simplify my invoicing.

Thank you

 

[Kalim Shaikh]

My suggestion is to create the source table on the same page on the next cells and select the index and match formula۔
The sample sheet given below may give you desired result.

ExportMyInvoice.xlsx
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q
1										SOURCE DATA
2
3	Item	SKU	Price Per Piece	Qty Sold	Net Amount	Vat 5%	Total			Item	SKU	Price Per Piece	Qty Sold	Net Amount	Vat 5%	Total
4	Drop Down List	76071040	233.33	2	466.66	11.67	490			Drop Down List	76071040	233.33	1	233.33	11.67	245
5	Drop Down List	76071031	566.67	2	566.67	28.33	623.3			Drop Down List	76071031	566.67	1	566.67	28.33	595
6
7
8
9
Sheet3

Cell Formulas
Range	Formula
B4:B5	B4	=INDEX(K4,MATCH(A4,J4,0))
C4:C5	C4	=INDEX(L4,MATCH(A4,J4,0))
E4	E4	=C4*D4
G4:G5	G4	=E4+F4*D4