Excel – VLookups and HLookups - AdvantEdge Training & Consulting

Excel – VLookups and HLookups

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.

Become a Master of Spreadsheets with an Excel training class from AETC

If you have at least 5 people we can create a session just for you.  Or, you can contact us for a private session. Contact Us

Questions? Don't see what you need?

We can help!

Business Training Classes
AdvantEdge Training & Consulting, Inc.

Recent Posts

Subscribe to our Newsletter

Copyright AdvantEdge Training & Consulting

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Scroll to Top