Excel Lookup Deep Dive: VLOOKUP, XLOOKUP, INDEX-MATCH & More

Master Microsoft Excel VLOOKUP, HLOOKUP, LOOKUP, INDEX-MATCH, XLOOKUP, XMATCH, Two-Dimensional Lookups & Data Validation

Created by: Robin Davis
Software Instructor and Excel Specialist

Created by: Steve McDonald
Dedicated Instructor Will Help You Excel | 300K+ Students

What Will I Learn?

• How to use Excel lookup functions including VLOOKUP, HLOOKUP, INDEX-MATCH, LOOKUP, XLOOKUP, and XMATCH
• How to add data validation to make your lookup projects more interactive and easier to use
• How to correct the errors that most commonly arise when creating lookup formulas
• How to create and use named ranges in lookup projects
• How to create nested lookup functions
• How to perform two-dimensional lookups

Requirements

• Access to Excel 2010 or later
• Basic Excel skills (e.g., ability to create basic formulas and use simple functions such as SUM and AVERAGE)

Target audience

• The Excel user who wants to be able to confidently use lookup functions
• The Excel user who wants to gain a deep understanding of how lookup functions work and wants to learn more than just how to use VLOOKUP
• The Excel user who is looking to enhance their knowledge of Excel and learn lookup concepts that can take their productivity and efficiency to the next level