Download Excel File: https://excelisfun.net/files/EMT1489.xlsx
Entire page with all Excel Files for All Videos: http://people.highline.edu/mgirvin/excelisfun.htm

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.