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. 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.
To Know more about the function watch this video till the end.
Also Watch New Functions of Excel #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