INDEX Function in Google Sheets

Syntax

INDEX(reference, [row], [column])

Description

Returns the content of a cell specified by row and column offset.

Tips & Best Practices

Pair with MATCH for flexible lookups that aren't limited to searching the first column.

Example

=INDEX(...)

The INDEX function belongs to the Lookup category of Google Sheets functions.

Related Functions

• VLOOKUP — Searches down the first column of a range for a key and returns the value of a s...
• HLOOKUP — Searches across the first row of a range for a key and returns the value of a sp...
• MATCH — Returns the relative position of an item in a range that matches a specified val...
• XLOOKUP — Searches a range for a match and returns a corresponding item from another range...
• LOOKUP — Looks through a row or column for a key and returns the value of the cell in a r...
• INDIRECT — Returns the reference specified by a text string....

Need Help with INDEX?

If you're struggling with INDEX or need a custom formula built for your business, our Google Sheets experts can help. Get a free quote →