3 VLOOKUPS Calculate Cost Based on Product, Packaging, Discount
See Mr Excel and excelisfun use two methods to calculate the total costs when there are three factors that go into calculating costs: Product Name, Packaging Type and Discount Based on Quantity Purchased. This requires three lookups:
1) Mr Excel uses 2 INDEX functions and the RIGHT functions with a VLOOKUP all inside the ROUND function.
2) Excelisfun uses 3 VLOOKUPS a SUM and the ROUND function.