Excel: VLOOKUP and XLOOKUP for Beginners
24mBeginner2024-10-02
Authors
Jess Stratton
LinkedIn Learning Staff Author, Tech Consultant
Course details
Many Excel users hear “VLOOKUP” and envision a complicated function reserved only for power users. Not so! VLOOKUP—and XLOOKUP, the newer version for 365 subscribers—are among Excel’s most powerful functions, yet you can master them with a few simple steps. In this mini-course, Jess Stratton walks you step-by-step through creating a simple lookup in Excel using both VLOOKUP and XLOOKUP, then shows you how to error-proof your formulas. Supercharge your Excel skills and save time with these powerful lookup functions.
Skills covered
SpreadsheetsMicrosoft ExcelBusiness Software and ToolsMicrosoftOne-Off
Concepts
0. Introduction
- 01 - Find data quickly in Excel
- 02 - What can you do with XLOOKUP in Excel
1. Using Lookup Functions
- 03 - Creating a simple XLOOKUP
- 04 - Creating a simple VLOOKUP
- 05 - Handling errors with the @IFERROR function
- 06 - Use dropdown lists and Excel tables for more error-proofing
Conclusion
- 07 - Expand your Excel function and formula skills
Related courses
- Excel: VLOOKUP and XLOOKUP for Beginners (2021)
- Excel: Advanced Formulas and Functions
- Excel: Lookup Functions in Depth
- From Excel to SQL (2021)
- Excel for Mac: Advanced Formulas and Functions (365/2019)
- Excel: Advanced Formulas and Functions (2023)
- Excel: Lookup Functions in Depth (2020)
- Mastering Lookup Functions in Excel: Seven Powerful Formulas
Related learn paths
- Excel Boot Camp
- Advance Your Skills with Excel Formulas and Functions
- Master Microsoft Excel
- Prepare for the Excel Expert - Microsoft Office Specialist Exam for M365 Apps (MO-211)
- Improve Your Microsoft Excel Skills
- Build Your Excel Skills
- Advance Your Python in Excel Skills
- Master Key Financial Analyst Skills