Excel Magic Trick 1489

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

DESCRIPTION

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.

WORKBOOKS

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







Be the first to comment

Leave a Reply