Lookup Functions in Excel – (Recorded Webinar)

This Lookup Functions in Excel webinar introduces some essential functions like VLOOKUP, HLOOKUP, and more.

Excel lookup functions are a handy tool to validate and analyze your data.

Deb Ashby, your professional trainer, discusses:

• What are Lookup Functions?
• A Basic Example of a Lookup
• VLOOKUP (Exact Match)
• VLOOKUP (Approx. Match)
• HLOOKUP
• The Limitations of VLOOKUP
• INDEX and MATCH
• XLOOKUP
• UNIQUE lists and Data Validation
• Performing 2-Way Lookups
• The CHOOSE Function

Watch the session here, download the files to follow along.

Lookup Functions in Excel – Recorded Webinar

Download the files and follow along.

Other Microsoft Webinars:

Advanced PowerPoint Hacks 2022 – Recorded Webinar

How to Use Logical Functions in Excel – (Recorded Webinar)

Advanced Word Tutorial: Tips and Tricks in MS Word – Recorded Webinar

Please visit our free Excel resources center for more high-quality Excel guides.

Simon Calder

Chris “Simon” Calder was working as a Project Manager in IT for one of Los Angeles’ most prestigious cultural institutions, LACMA.He taught himself to use Microsoft Project from a giant textbook and hated every moment of it. Online learning was in its infancy then, but he spotted an opportunity and made an online MS Project course - the rest, as they say, is history!