INDEX()
Returns the value at a given row and column position within a range.
INDEX(array, row_num, [column_num])INDEX returns whatever sits at a specific row/column position inside a range. On its own it's a simple lookup by position — it becomes powerful when row_num comes from MATCH instead of a fixed number.
Paired as INDEX(MATCH(...)), it replaces VLOOKUP for cases that need to look left, or that shouldn't break when a column is inserted.
Arguments
- array
- The range to pull a value from.
- row_num
- Which row of array to return, counting from 1.
- column_numoptional
- Which column of array to return, counting from 1. Omit for a single-column array.
Examples
=INDEX(A2:A10, 3)→Row 3's value
Returns the 3rd item down in a single column.
=INDEX(A2:C10, 3, 2)→Row 3, column 2's value
Returns the value at the intersection of row 3 and column 2 of the range.