INDEX function in Excel

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.

From the lesson INDEX Function.

Common mistakes

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

Related lookup functions

• VLOOKUPLooks down the first column of a table and returns a value from another column.
• HLOOKUPLooks across the first row of a table and returns a value from another row.
• XLOOKUPFinds a value in one range and returns the matching item from another.
• MATCHReturns the position of a value in a range.
• XMATCHPosition of a value in a list; exact match by default.