Excel functions: INDEX + MATCH

The INDEX function used together with the MATCH function allows us to search for a value in an array.

Let's try an example:

We want to be able to find a person's age and/or city based on his or her first name (this could also be done based on age or city).

Here is the formula:


index match function
index match functions

If we edit H6, we will get:

index match


In this example, we have used the following syntax:


We could also have used the syntax below (in this version, the result returned by the MATCH function will be the column number instead of the row number):