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.
Formula:
=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
