How to use Xmatch Function in Microsoft Excel | Learn in 5 Minutes
In this video we will see how to use xmatch function in microsoft Excel with mandatory arguments lookup_value and lookup_array. We will also learn how to use optional arguments match_mode and search_mode in detail. We will also have an insight on how binary search can boost the performance of Xmatch. Finally we will understand how we can use xmatch with index function.
How to use match function - • How to Use Match Function in Microsoft Exc...
How to use index + match to build two way lookup - • How to use Index + Match to build two way ...
0.00 - Intro
0.42 - Application of Xmatch
1.16 - Application of Match_Mode Argument
3.00 - Application of Search_Mode Argument
3.31 - Understanding Binary Search
6.47 - Combining Xmatch with Index
7.35 - Closure