One of the most requested training topics we receive is in how to create a V or H Lookup formula. There are multiple uses for them. You can use one to type in a name or number and have it bring up a corresponding piece of data from a list – for example typing an inventory number and having it display the product name or location. Or you can use it to provide an automatic discount or penalty based on a schedule of the same – for example have it apply a penalty based on the % of days an invoice is past due, based on a penalty schedule you have created.
In this video we will look at how to use them for a schedule of discounts. This will help us calculate how much of a discount a client gets on their order, based on the quantity of items they order, that is compared to our discount schedule.
