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 one way to use them by typing in an inventory number and having it display a product name from a list. We will also discuss the difference between an V & H Lookup.
