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. |
© 2023 Better Solutions Limited. All Rights Reserved. © 2023 Better Solutions Limited Top