Excel Magic Trick 1489

2 VLOOKUP in 1 Formula: Lookup Correct Volume Discount Product Price


In this video learn how to create a single Excel formula that will lookup a product price and lookup the volume / quantity discount and deliver the correct discounted Product Price. See how to use the VLOOKUP Function with an Exact Match lookup and an Approximate Match Lookup. Also see how to use the ROUND Function to round to the penny.


Download “Excel Magic Trick 1481-1490” Excel-Magic-Trick-1481-1490.zip – Downloaded 198 times – 2 MB

Be the first to comment

Leave a Reply