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
Let us match and find the position of an item, using the MATCH function, with the help of the below video