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(Office 365) The array of 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.
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(365 Insiders) The value from a cell range which is the intersection of a row OR a column.
SORT(365 Insiders) The array of data in a range that has been sorted.
SORTBY(365 Insiders) The array of data in a range that has been sorted and satisfies multiple conditions.
TRANSPOSEThe array with its orientation changed.
UNIQUE(365 Insiders) 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(365 Insiders) The value in the same row after finding a matching value in any column.
XMATCH(365 Insiders) 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
(Office 365) The array of 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.
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
(365 Insiders) The value from a cell range which is the intersection of a row OR a column.
SORT
(365 Insiders) The array of data in a range that has been sorted.
SORTBY
(365 Insiders) The array of data in a range that has been sorted and satisfies multiple conditions.
TRANSPOSE
The array with its orientation changed.
UNIQUE
(365 Insiders) 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
(365 Insiders) The value in the same row after finding a matching value in any column.
XMATCH
(365 Insiders) The position of a value in a list, table or cell range.

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