How XLOOKUP works
What you will learn?
Please download this practice file to use while you watch the videos
Each tab ties into a lesson or video
Please download the completed practice file with populated formulas and functions
A quick introduction
A quick overview of Part I
Overview of the XLOOKUP Syntax
Learn how to use XLOOKUP, why it is more flexible than VLOOKUP and how to handle errors
In this lesson we cover how XLOOKUP can lookup both vertically and horizontally
In this lesson we look at how XLOOKUP can return dynamic ranges both vertically and horizontally
Learn how XLOOKUP has greater flexibility than other LOOKUP functions and can look up in any order
In this lesson we cover how to use XLOOKUPs match mode
In this lesson we cover how to use XLOOKUPs search mode
In this lesson we cover how to use XLOOKUP to return data, regardless of location
In this lesson we learn how to use XLOOKUP as a replacement for INDEX and MATCH
Now that you have a solid understanding of XLOOKUP, Part II covers how to use XLOOKUP to aid your financial storytelling and data analysis
In this module we look at how to use XLOOKUP to unpivot data to convert a grouped data view into a list of data.
