INDEX Function

Freeintermediate 15 min4 tasks0/54 pts

INDEX returns the value at a given position in a range. For a single column give it a row number; for a table give a row and a column number. It does the opposite of MATCH.

Syntax

INDEX(array, row_num, [column_num])

Example: =INDEX(A2:D6,4,3) returns the value in the 4th row and 3rd column of the table.

Common mistakes

A position larger than the range gives #REF!.
Counting positions from the sheet instead of from the range.

MATCH Practice INDEX MATCH Lookup