by 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
