Play Speed
  • 0.5x
  • 1x (Normal)
  • 1.25x
  • 1.5x
  • 2x
6 Lessons (21m)
    • 1. XLOOKUP Class Introduction

      1:11
    • 2. Limitations of VLOOKUP

      2:18
    • 3. Xlookup

      6:29
    • 4. Xlookup match modes

      4:53
    • 5. Xlookup search types

      4:54
    • 6. XLOOKUP Class Conclusion

      0:49

About This Class

Move over VLOOKUP - Here comes XLOOKUP

VLOOKUP is one of those functions’ users tend to use over and over.  At the start it is hard to get your head around it but once you do, it provides great value. However, it also has its limitations. For example, on its own it cannot look up to the left.  You cannot do a horizontal lookup. You cannot add new columns to the dataset for fear of breaking the formula.

XLOOKUP aims to solve the limitations posed by VLOOKUP, it will be easier to read and write and it will calculate faster. This function will be available in Office 365.

In this class, you will learn how to use XLOOKUP and we will examine the search types and the match modes.

42efbc70