MATCH Function

The MATCH function shows the position of an item in a list. The function gives the position of either the text or the numbers.
Note: The function can be used to get exact or approximate match.


=MATCH(lookup value, lookup array, match type)
Match type can be 0, 1 or -1.
0 - looks for the exact match and returns the position. If not found, it returns #N/A.
1 - looks for the next lowest number if no exact match exists.
-1 - looks for the next highest number if no exact match exists

Video Tutorial:

Let us match and find the position of an item, using the MATCH function, with the help of the below video

Learn MS Excel

Ask Questions

Ask Question