Dueling Excel 110

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.


Be the first to comment

Leave a Reply