Today I am going to tell you about the #XMATCH function, as well as we will learn how it's better than the #MATCH Function. br XMATCH Function is a new Function introduce in Ms Excel Office 365. This is an improved version of MATCH Function that works in any direction and returns exact match by default, making it easier and more convenient to use. Well if we want position of approximate value, then XMATCH Function easily identify the position in a range or array. Because if you are using MATCH Function for the same thing than, you have to sort data in ascending or descending order after that you will get the correct position.br br To Know more about the function watch this video till the end.