INDEX

Lookup & referenceExcel 2007

Return the value at a given row/column position in a range.

Syntax

INDEX(array, row_num, [column_num])

Arguments

array: The range or array.
row_num: Row position within the range (1-based). 0 = whole column.
column_numoptional: Column position. Omit for a single-column range.

Examples

=INDEX(C2:C100, MATCH(A2, A2:A100, 0))

→ INDEX/MATCH lookup

=INDEX(data, 0, 3)

→ the entire 3rd column

Good to know

INDEX returns a reference, so INDEX(...):INDEX(...) can build a dynamic range.

Related functions

MATCH XLOOKUP OFFSET CHOOSE

More Lookup & reference functions

ADDRESS AREAS CHOOSE COLUMN COLUMNS FORMULATEXT GETPIVOTDATA HLOOKUP HYPERLINK INDIRECT LOOKUP MATCH

← All 510 functions

Syntax follows Microsoft’s documentation. Examples are written to be pasted into a cell and checked. Argument separators may be ; in your locale. The AI explainer runs on a free community model — verify anything important.