This is the #XMATCH Function Part-2, in part-1 we have covered the basics of XMATCH Function that why and how to use XMATCH Function and how its better than #MATCH Function and also cover how XMATCH Function do exact match & approximate match. Now we will know about XMATCH Function Optional argument #match_mode and the topic is how to use wild card character match. If you are using match function this option not available there, hence you cannot find any wildcard character directly via MATCH or any Lookup function, but XMATCH Function having option to do it, along with that XMATCH Function have a new option argument #Search_Mode that will also a very unique things with the function, its help us to search & lookup data from bottom to top or Last to First.
In this video you can learn more things about new XMATCH Function, so watch this video till the end.
Download Practice file here https://mega.nz/file/B6AS0b5D#aNtvfoj4_xtk53xrZhCMAoDwEdBFTj5YeQD0-JEorgw
Also Watch New Functions of Excel.
#XMATCH Function https://dai.ly/x7wc0uu https://youtu.be/w8pWKjMyLgA
#SORTBY Function https://dai.ly/x7wb9xg https://youtu.be/Ojm5Xaff5hE
#SORT Function https://dai.ly/x7wb9xf https://youtu.be/Bnw943d1Fpw
UNIQUE Function https://dai.ly/x7w0iya https://youtu.be/N4k5_hiB9fA
#FILTER Function https://dai.ly/x7w0k5o https://youtu.be/9u9ncDUfmpE
#XLOOKUP Function https://dai.ly/x7vzdl0 https://youtu.be/15ziUhOp-3M
Subscribe YouTube & Follow on Dailymotion https://www.YouTube.com/c/exceluniverse https://www.dailymotion.com/exceluniverse
