XLOOKUP | Masterclass on XLOOKUP | Excel 365 | Excel 365 Functions | All in One Lookup Function

Hi All

This Video explains all aspects and functionalities of XLOOKUP function
Currently this function is available in Excel 365 Only
This function can replace VLOOKUP, HLOOKUP and INDEX/MATCH

Also this function is amazingly easy to learn
Do watch the video for that

Practice File Link:

Please note that this file is not compatible with Excel 2019 or earlier versions
The file will open but functions cannot be decoded

Chapters:
00:00 Introduction
00:40 Syntax of XLOOKUP
01:37 Basic XLOOKUP
07:19 Lookup Arrays
08:47 Last Value Lookup
10:16 Lookup Horizontally and/or Vertically
12:13 2 Criteria Lookup
13:22 Multiple Criteria Lookup
15:41 Closing Notes

Excel Insider

#Excel365
#Xlookup
#ExcelFormulas

XLOOKUP
Masterclass on XLOOKUP
Excel 365
Excel 365 Functions
All in One Lookup Function