Google Sheets Function: MATCH

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


=MATCH(search_key, range, search_type)

Example of use

The MATCH function here needs to return the position of the searched city in the list of cities:

google sheets match function

Enter into the MATCH function:

The formula here is:

google sheets match function position

In this example, "Dublin" is indeed the seventh cell in the range B2 to B11.

With the position returned by MATCH, it will then be possible to display the file number of the searched city as well as the number of points using the INDEX + MATCH combination.