Lookup & Reference Functions

ADDRESSThe cell reference given a row and column number.
AREASThe number of areas in a cell range or reference.
CHOOSEThe value in a row (or column) based on an index number.
COLUMNThe column number of a cell reference.
COLUMNSThe number of columns in a cell range or reference.
FILTER(2021) The array after filtering data that satisfies multiple conditions.
FORMULATEXT(2013) The formula from a particular cell.
GETPIVOTDATAThe data obtained from a pivot table.
HLOOKUPThe value in the same column after finding a matching value in the first row.
HYPERLINKThe hyperlink linked to a cell, document or webpage.
INDEXThe value from a cell range which is the intersection of a row AND a column.
INDIRECTThe value of a given cell reference specified by a text string.
LET(2021) The result of a formula that can use variables.
LOOKUPThe value in a row (or column) that matches a value in a column (or row).
MATCHThe position of a value in a list, table or cell range.
OFFSETThe value in a cell which is an offset from another cell.
ROWThe row number of a cell reference.
ROWSThe number of rows in a cell range or reference.
RTDThe 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 that has been sorted by one column.
SORTBY(2021) The array of data that has been sorted based on multiple columns.
STOCKHISTORY(Microsoft 365) The historical data about a financial instrument.
TRANSPOSEThe array with its orientation changed.
UNIQUE(2021) The array of unique values in a list, table or cell range.
VLOOKUPThe 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 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 that has been sorted by one column.
SORTBY
(2021) The array of data that has been sorted based on multiple columns.
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.

© 2024 Better Solutions Limited. All Rights Reserved. © 2024 Better Solutions Limited Top