Type in Google’s function list
Lookup functions
Functions that find values and addresses in a range. Google prints 17 Lookup function(s) in its Google Sheets function list.
| Function | Syntax as printed | Description from Google Docs Editors Help |
|---|---|---|
| ADDRESS | ADDRESS(row, column, [absolute_relative_mode], [use_a1_notation], [sheet]) | Returns a cell reference as a string. |
| CHOOSE | CHOOSE(index, choice1, [choice2, ...]) | Returns an element from a list of choices based on index. |
| COLUMN | COLUMN([cell_reference]) | Returns the column number of a specified cell, with `A=1`. |
| COLUMNS | COLUMNS(range) | Returns the number of columns in a specified array or range. |
| FORMULATEXT | FORMULATEXT(cell) | Returns the formula as a string. |
| GETPIVOTDATA | GETPIVOTDATA(value_name, any_pivot_table_cell, [original_column, ...], [pivot_item, ...] | Extracts an aggregated value from a pivot table that corresponds to the specified row and column headings. |
| HLOOKUP | HLOOKUP(search_key, range, index, [is_sorted]) | 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 | INDEX(reference, [row], [column]) | Returns the content of a cell, specified by row and column offset. |
| INDIRECT | INDIRECT(cell_reference_as_string, [is_A1_notation]) | Returns a cell reference specified by a string. |
| LOOKUP | LOOKUP(search_key, search_range|search_result_array, [result_range]) | 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 | MATCH(search_key, range, [search_type]) | Returns the relative position of an item in a range that matches a specified value. |
| OFFSET | OFFSET(cell_reference, offset_rows, offset_columns, [height], [width]) | Returns a range reference shifted a specified number of rows and columns from a starting cell reference. |
| ROW | ROW([cell_reference]) | Returns the row number of a specified cell. |
| ROWS | ROWS(range) | Returns the number of rows in a specified array or range. |
| SHEET | SHEET(value) | Returns the sheet number of the specified sheet or other reference. |
| VLOOKUP | VLOOKUP(search_key, range, index, [is_sorted]) | 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. |
| XLOOKUP | XLOOKUP(search_key, lookup_range, result_range, missing_value, [match_mode], [search_mode]) | Returns the values in the result range based on the position where a match was found in the lookup range. If no match is found, it returns the closest match. |
Source: Google Docs Editors Help, “Google Sheets function list” (support.google.com/docs/table/25273), data fetched 28 September 2026. Data month: September 2026. Every function name in Google’s list is placed under one type; a function carries the type the list prints for it.