How To Use XLOOKUP | Why XLOOKUP is Better Than Any Other Lookup Siblings | Learn Binary Search Mode
In this video, we will learn how to use xlookup function and how xlookup function is better than any other lookup siblings in microsoft excel. Xlookup not only has all the features of index match, lookup, hlookup and vlookup put together but also bundle of new features. You will also learn binary search mode which will boost the speed of Xlookup beyond imagination.
Chapters
00:00 - Intro
01:04 - Application of Xlookup Function
02:40 - Argument - if not found
03:09 - Argument - Match Mode
04:25 - Argument - Match Mode (Wildcard)
05:00 - Argument - Search Mode
05:37 - Argument - Search Mode (Binary Search)
08:42 - Closer