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.br Now we will know about XMATCH Function Optional argument #matchmode 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 #SearchMode 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.br br In this video you can learn more things about new XMATCH Function, so watch this video till the end.br br Download Practice file here br br br Also Watch New Functions of Excel.