MATCH function in Excel | Advance Excel Course

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.


MATCH(lookup_value, lookup_array, [match_type])


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 :