Lookup & Reference Functions

ADDRESS	The cell reference given a row and column number.
AREAS	The number of areas in a cell range or reference.
CHOOSE	The value in a row (or column) based on an index number.
COLUMN	The column number of a cell reference.
COLUMNS	The number of columns in a cell range or reference.
FILTER	(2021) The array after filtering data in a range that satisfies multiple conditions.
FORMULATEXT	(2013) The formula from a particular cell.
GETPIVOTDATA	The data obtained from a pivot table.
HLOOKUP	The value in the same column after finding a matching value in the first row.
HYPERLINK	The hyperlink linked to a cell, document or webpage.
INDEX	The value from a cell range which is the intersection of a row AND a column.
INDIRECT	The value of a given cell reference specified by a text string.
LET	(2021) The result of a formula that can use variables.
LOOKUP	The value in a row (or column) that matches a value in a column (or row).
MATCH	The position of a value in a list, table or cell range.
OFFSET	The value in a cell which is an offset from another cell.
ROW	The row number of a cell reference.
ROWS	The number of rows in a cell range or reference.
RTD	The real time data from a program that supports COM.
SINGLE	(2021, Removed in 365) The value from a cell range which is the intersection of a row OR a column.
SORT	(2021) The array of data in a range that has been sorted by one column.
SORTBY	(2021) The array of data in a range that has been sorted based on multiple columns or values in a range.
STOCKHISTORY	(Microsoft 365) The historical data about a financial instrument.
TRANSPOSE	The array with its orientation changed.
UNIQUE	(2021) The array of unique values in a list, table or cell range.
VLOOKUP	The value in the same row after finding a matching value in the first column.
XLOOKUP	(2021) The value in the same row after finding a matching value in any column.
XMATCH	(2021) The position of a value in a list, table or cell range.

ADDRESS The cell reference given a row and column number.
AREAS The number of areas in a cell range or reference.
CHOOSE The value in a row (or column) based on an index number.
COLUMN The column number of a cell reference.
COLUMNS The number of columns in a cell range or reference.
FILTER (2021) The array after filtering data in a range that satisfies multiple conditions.
FORMULATEXT (2013) The formula from a particular cell.
GETPIVOTDATA The data obtained from a pivot table.
HLOOKUP The value in the same column after finding a matching value in the first row.
HYPERLINK The hyperlink linked to a cell, document or webpage.
INDEX The value from a cell range which is the intersection of a row AND a column.
INDIRECT The value of a given cell reference specified by a text string.
LET (2021) The result of a formula that can use variables.
LOOKUP The value in a row (or column) that matches a value in a column (or row).
MATCH The position of a value in a list, table or cell range.
OFFSET The value in a cell which is an offset from another cell.
ROW The row number of a cell reference.
ROWS The number of rows in a cell range or reference.
RTD The real time data from a program that supports COM.
SINGLE (2021, Removed in 365) The value from a cell range which is the intersection of a row OR a column.
SORT (2021) The array of data in a range that has been sorted by one column.
SORTBY (2021) The array of data in a range that has been sorted based on multiple columns or values in a range.
STOCKHISTORY (Microsoft 365) The historical data about a financial instrument.
TRANSPOSE The array with its orientation changed.
UNIQUE (2021) The array of unique values in a list, table or cell range.
VLOOKUP The value in the same row after finding a matching value in the first column.
XLOOKUP (2021) The value in the same row after finding a matching value in any column.
XMATCH (2021) The position of a value in a list, table or cell range.