Home/Formulas/Lookup/INDEX
Lookupmedium

INDEX()

Returns the content of a cell at a given row and column in a range.

Syntax
fx
=INDEX(reference, [row], [column])
Try it
F2
→
Globex
Sample data · sales.csv
ABCD
1CompanyRegionQuarterRevenue
2Acme CoWestQ118,400
3Acme CoWestQ222,100
4Acme CoWestQ331,700
5Acme CoWestQ448,200
6GlobexEastQ114,200
7GlobexEastQ219,800
8GlobexEastQ323,400

Common pitfalls

  • Row and column indices are 1-based, not 0-based. INDEX(A1:D10, 1, 1) returns A1, not B2.
  • Pass 0 for row OR column to return the entire other dimension as an array.
  • Pair with MATCH for the classic flexible-lookup pattern: INDEX(result_col, MATCH(key, lookup_col, 0)).
Related formulas
MATCH()
Returns the relative position of a value in a range.
VLOOKUP()
Vertical lookup. Searches the first column of a range and returns a value from a specified column.
Used by
VLOOKUP()
Vertical lookup. Searches the first column of a range and returns a value from a specified column.
XLOOKUP()
The modern replacement for VLOOKUP. Searches any column, returns from any column.
MATCH()
Returns the relative position of a value in a range.
More Lookup formulas →Keyboard shortcuts for Sheets →