How to use MATCH function in Excel
In this blog, we will be discussing MATCH function in excel. MATCH function basically helps in finding the position of a value. It will not fetch any number but will provide only the position of the lookup value in excel. This function is very helpful when it works with other functions like OFFSET/INDEX.
Let us understand the anatomy of excel MATCH function. It requires 3 input values as can be seen in the below picture.
match_type can be explained as below:
In example 1: we will try to find out the position of USA in the country … Continue Reading