Download Files: Start Excel File: https://excelisfun.net/files/EMT1479-1481.xlsx
Entire page with all Excel Files for All Videos: http://people.highline.edu/mgirvin/excelisfun.htm
Learn about how to
In this video learn the Basics of VLOOKUP to looks up a price based on a Bulk Quantity Discount. Also learn about the MATCH Function to automatically pick out the correct Column Number for the VLOOKUP Function.
1. (00:01) Introduction
2. (00:14) Use VLOOKUP and Column Index Number to lookup a price based on a Quantity Discount
3. (05:14) Use VLOOKUP and MATCH to lookup a price based on a Quantity Discount
4. (09:44) Summary