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
Quick introduction and 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
XLOOKUP can lookup both vertically and horizontally
With XLOOKUP, you 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
Learn how and when to use XLOOKUPs match mode
Learn how to use XLOOKUPs search mode
Learn how to use XLOOKUP to return data, regardless of location
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
Learn how to unpivot data to convert a grouped data view into a list of data.
