XLOOKUP Function - The Successor to VLOOKUP and Its Much Better

Alan Murray, IT Trainer, Coffee Lover and Lifelong learner

Play Speed
  • 0.5x
  • 1x (Normal)
  • 1.25x
  • 1.5x
  • 2x
9 Lessons (35m)
    • 1. Introduction

      2:35
    • 2. Using the XLOOKUP Function - The VLOOKUP Successor

      5:29
    • 3. Performing a Range Lookup with XLOOKUP

      4:30
    • 4. Finding the Last match and Using Wildcards

      4:00
    • 5. Looking Along a Row - HLOOKUP Replacement

      1:51
    • 6. Lookup using Multiple Criteria

      2:20
    • 7. Creating a Two Way Lookup

      3:54
    • 8. Using XLOOKUP with other Functions

      4:17
    • 9. Creating Dependent Drop Down Lists

      5:58

About This Class

In this class, you will learn the new XLOOKUP function of Excel. This awesome new function is the successor to VLOOKUP and HLOOKUP (you can now forget about those functions).

VLOOKUP is the third most commonly used function of Excel (statistics from Microsoft), but it was heavily limited despite how handy it was.

XLOOKUP changes all this. The previous limitations have been fixed and there are also additional features that this function brings.

This class will show you how to use XLOOKUP, why its better than VLOOKUP and also show some advanced uses of the function.

Note: XLOOKUP is currently available only to Office Insiders and will be available publicly very soon. You can sign up to be an Office Insider here.

Download the practise file to follow along with the videos and the project file for the exercises afterwards.

Any questions, please post them and I will get back to you.

I will see you in the class.