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.
CHOOSECOLS(Microsoft 365) The specified columns from an array.
CHOOSEROWS(Microsoft 365) The specified rows from an array.
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 text string of the contents of a given cell reference.
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, Deprecated) 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.
SORTBY(2021) The array of data in a range that has been sorted based on the values in a corresponding 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.
CHOOSECOLS
(Microsoft 365) The specified columns from an array.
CHOOSEROWS
(Microsoft 365) The specified rows from an array.
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 text string of the contents of a given cell reference.
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, Deprecated) 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.
SORTBY
(2021) The array of data in a range that has been sorted based on the values in a corresponding 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.

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