Register Online - Add to Cart


Sponsored by Lorman Education
Product ID: 407764EAU
Credit & Course Provided by:

Excel: Mastering Lookup Functions

OnDemand Webinar (55 minutes)

Gain in-depth knowledge of the Lookup functions in Excel®.VLOOKUP, HLOOKUP, INDEX and MATCH are some of the most well-known (and most useful) formulas in Excel®. Used properly, they will help you to improve the accuracy and integrity of your Excel® workbooks, save a ton of time and minimize data entry errors. This topic is categorized as intermediate-to-advanced. It is aimed at users who want to learn about the Lookup functions in Excel®.


Mike Thomas,


How to Construct and Use the VLOOKUP Function

TRUE and FALSE - the 4th Parameter Demystified

Tables - the Key to Future-Proofing VLOOKUP

Using MATCH and COUNTIF Functions to Compare Two Lists


How to Construct and Use the HLOOKUP Function

The LOOKUP Function

How to Avoid #NA