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
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
Category
📚
Learning