Excel Magic Trick 1489: 2 VLOOKUP in 1 Formula: Lookup Correct Volume Discount Product Price

Download Excel File: https://ift.tt/2FBZxgi
Entire page with all Excel Files for All Videos: https://ift.tt/1kSFWvs

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.

View on YouTube