Download Files: Start Excel File: http://ift.tt/2pj6AUR
Entire page with all Excel Files for All Videos: http://ift.tt/1zHY6GI 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