calculate the price for each of the items given quantity purchased using vlookup and mixed reference

sum of each row to get row total

calculate total after discount

Total Price ($) Quantity (This formula combines VLOOKUP & mixed reference) VitD3 Puritan VCGNC VC LifeExtension V Emergend VitD3 Puritan VC GNC VC LifeExtension V(Emergenc ($) Total- Discount after Item Name Unit Price Threshol Disc Discount VitaminD3 $ 2.25 $ - 0 Puritan Vitc $ 5.99 $ 50.00 20% GNC Vitc $ 4.99 $ 70.00 30% LifeExtension Vit $ 7.50 $ 100.00 35% Emergenc $ 12.99 Contreras Cruz De Grinis Dones Escamilla Hernandez lic Kovacs Lopez Martinez Park Foto The above data is given and canNOT be changed. Calculate the price for each of the items given quantity purchased Sum each row to get row total Total Price ($) Quantity (This formula combines VLOOKUP & mixed reference) VitD3 Puritan VCGNC VC LifeExtension V Emergend VitD3 Puritan VC GNC VC LifeExtension V(Emergenc ($) Total- Discount after Item Name Unit Price Threshol Disc Discount VitaminD3 $ 2.25 $ - 0 Puritan Vitc $ 5.99 $ 50.00 20% GNC Vitc $ 4.99 $ 70.00 30% LifeExtension Vit $ 7.50 $ 100.00 35% Emergenc $ 12.99 Contreras Cruz De Grinis Dones Escamilla Hernandez lic Kovacs Lopez Martinez Park Foto The above data is given and canNOT be changed. Calculate the price for each of the items given quantity purchased Sum each row to get row total