Excel Magic Trick 1479

Lookup Bulk Quantity Discount Prices Using VLOOKUP Function

DESCRIPTION

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.
(00:01) Introduction
(00:14) Use VLOOKUP and Column Index Number to lookup a price based on a Quantity Discount
(05:14) Use VLOOKUP and MATCH to lookup a price based on a Quantity Discount
(09:44) Summary

WORKBOOKS

Download “Excel Magic Trick 1469-1481” Excel-Magic-Trick-1469-1481.zip – Downloaded 195 times – 4 MB







Be the first to comment

Leave a Reply