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 in a range 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 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.
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 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.

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