MATCH() returns the position of a cell in a row or column.
The Excel MATCH function searches for a lookup value in a range of cells and returns the relative position of that value in the range.
Syntax
MATCH(lookup_value, lookup_array, [match_type])
Arguments
1. lookup_value - the number or text value you are looking for.
2. lookup_array - a range of cells being searched.
3. match_type - specifies whether to return an exact match or the nearest match:
find row index position number using Match
find Column index position number using Match
Example :
