Practical Uses of Lookup Functions in Excel – Recorded Webinar
This recorded live webinar walks you through the practical uses of lookup functions in Excel.
Deb Ashby, your Excel expert and Microsoft MVP, will teach you the different lookup functions that are available in Microsoft Excel and how to use them, including basic examples. Learn about the popular VLOOKUP, how to perform flexible lookups using INDEX and MATCH functions, and more!
This webinar covers the following:
- What are lookup functions?
- VLOOKUP exact match
- The disadvantage of VLOOKUP
- VLOOKUP approximate match
- Lookups with data validation
- INDEX and MATCH for flexible lookups
- The XLOOKUP function
- Two-way lookups
- Lookups with duplicate values
Watch the session here, and download the instructor demo files to follow along.
Practical Uses of Lookup Functions in Excel – Recorded Webinar
Download the instructor files and follow along.
Other Microsoft Webinars:
Practical Uses of Logical Formulas in Excel
New Dynamic Array Functions in Excel
Please visit our free Microsoft Office resources center for more high-quality Microsoft 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!
