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