Excel Function: MATCH

The Excel function MATCH searches for the position of a value in a range of cells.


=MATCH(lookup_value, range, match_type)

Example of Use

The goal here is to determine the position of the searched city in the list:

excel function match

Select the MATCH function and enter:

match function

The position of the city in the list is then displayed:


Indeed, London is in position number 3 in the cell range B2:B11.

If needed, you can download the Excel file used here: match.xlsx
Thanks to this position, it is then possible to display the file number of the searched city as well as the number of points using the combination: INDEX + MATCH