the XLOOKUP function Part I

If you’ve ever only known VLOOKUP or struggled with INDEX-MATCH, you’re going to love what comes next.

XLOOKUP is Excel’s game-changing function that makes searching, finding, and pulling data easier than ever.

In this course, you’ll learn how to:

- Replace outdated lookup formulas with XLOOKUP once and for all

- Handle errors gracefully and keep your spreadsheets clean

- Unlock the power of match mode and search mode

- Use nested XLOOKUPs to simplify what used to take INDEX and MATCH

By the end, you’ll not only understand XLOOKUP—you’ll be using it confidently to solve real-world problems, impress your coworkers, and save yourself tons of frustration.

Whether you’re a XLOOKUP beginner and tired of formula headaches, or an Excel pro looking to level up, this course is your shortcut to mastering the most powerful lookup function in Excel.

The course is divided into bite-sized videos, so you can learn at your own pace, watch them in any order, and easily revisit sections whenever you need a refresher