INDEX MATCH

INDEX MATCH is a lookup function that many considered to be stronger to the tried-and-true VLOOKUP function. While everyone read INDEXMATCH as one, it actually is combination of two functions Index and Match.

If you know how to use the Index and Match functions, you can comfortably implement the IndexMatch function. Don’t be worried if you have no idea how to use them. Click here to learn and practice them.

Syntax of INDEX MATCH function

Here’s how we use Indexmatch function:

=INDEX(array,MATCH(lookup_value,lookup_array,[match_type])

Let us understand in better with example:

Why Index Match Function?

I think INDEX function is quite useless. Who’s gonna remember the number of rows and columns to a given cell to extract the data. But if we combine the MATCH function inside the INDEX function, we don’t have to give the position explicitly.

As the match function itself returns relative positions of the matched object, we can use the MATCH function inside the INDEX function as our position argument to extract the value of the required number.

Example for Index Match function

The Result “80” without explicitly mentioning the row number as MATCH function ensures that for us.

So, in this way you can implement this in your working sheet to get the most out of MATCH & INDEX by combining it.

We have just discussed an example; But why don’t you practice it by yourself? Practice indexmatch online below.

Practice Index Match function below:

The formula can be entered in the highlighted cell. If the formula entered is correct, it shows good job. If the formula is entered incorrectly, the result will be invalid. Please keep in mind that you can only enter formula in the highlighted cells.

Hurray! You know now how to use Index Match function. Practice Index, Match, Vlookup, Multi Column Vlookup and other functions by checking our articles below.