Index Function

Index Function

The Index Function returns the value of an array given a specific row and column.

Syntax:

INDEX(array, row_num, [column_num])
array – this is a range of cells that you want to return a value from.
row_num – the row number in array from which you want to return a value. If omitted, the column_num is required.
column_num – the column number in array from which you want to return a value. If omitted, row_num is required.
Let’s look at the below example.

=INDEX(A2:C12,5,2)

Using the formula above, we set the search feature look from cell A2 through C12. Next, we want to return the value from Row 5, Column 2 (B).

Index function Download File

The end result is Alabama.

Index Function

Learn how to use the Index Function with the Match Function to replace vlookups. This tutorial will show you how to use the Index and Match Function together.

Was this article helpful?

Related Articles

Leave a Reply