Google Sheets lookup functions

Lookup functions in Google Sheets, explained with live examples.

18 lookup functions in Google Sheets — 2 documented in depth so far, the rest indexed below and landing every week.

Documented lookup functions

Syntax, examples, and the equivalent — ready now.

The full set — deep dives on the way.

ADDRESS: Returns a cell reference as a string.
CHOOSE: Returns an element from a list of choices based on index.
COLUMN: Returns the column number of a specified cell, with `A=1`.
COLUMNS: Returns the number of columns in a specified array or range.
FORMULATEXT: Returns the formula as a string. .
GETPIVOTDATA: Extracts an aggregated value from a pivot table that corresponds to the specified row and column headings.
HLOOKUP: Horizontal lookup. Searches across the first row of a range for a key and returns the value of a specified cell in the column found.
INDEX: Returns the content of a cell, specified by row and column offset.
INDIRECT: Returns a cell reference specified by a string.
LOOKUP: Looks through a row or column for a key and returns the value of the cell in a result range located in the same position as the search row or column.
MATCH: Returns the relative position of an item in a range that matches a specified value.
OFFSET: Returns a range reference shifted a specified number of rows and columns from a starting cell reference.
ROW: Returns the row number of a specified cell.
ROWS: Returns the number of rows in a specified array or range.
SHEET: Returns the sheet number of the specified sheet or other reference. .
VLOOKUP: Vertical lookup. Searches down the first column of a range for a key and returns the value of a specified cell in the row found.

More Google Sheets function categories