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
Introduction
- Find data quickly in Excel
- What can you do with XLOOKUP in Excel
Using Lookup Functions
- Creating a simple XLOOKUP
- Creating a simple VLOOKUP
- Handling errors with the @IFERROR function
- Use dropdown lists and Excel tables for more error-proofing
Conclusion
- Expand your Excel function and formula skills