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. |
| CHOOSECOLS | (2024) The array with just a specific number of columns. |
| CHOOSEROWS | (2024) The array with just a specifiic number of rows. |
| COLUMN | The column number of a cell reference. |
| COLUMNS | The number of columns in a cell range or reference. |
| DROP | (2024) The array without certain rows or columns. |
| EXPAND | (2024) The array expanded or padded to specific dimensions. |
| FIELDVALUE | (2024) The value in a particular field from a linked data type. |
| FILTER | (2021) The array after filtering data that satisfies multiple conditions. |
| FORMULATEXT | The formula from a particular cell. |
| GETPIVOTDATA | The data obtained from a pivot table. |
| GROUPBY | (365) Preview. The grouping of your data along one axis and aggregates the associated values. |
| HLOOKUP | (XLOOKUP) The value in the same column after finding a matching value in the first row. |
| HSTACK | (2024) The array after putting multiple arrays next to each other. |
| 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 | (XMATCH) 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. |
| PIVOTBY | (365) Preview. The grouping of your data along two axis and aggregates the associated values. |
| 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. |
| TAKE | (2024) The intersection of specific rows and columns in an array. |
| TOCOL | (2024) The array transformed into a single column. |
| TOROW | (2024) The array transformed into a single row. |
| TRANSPOSE | The array with its orientation changed. |
| TRIMRANGE | (365) Preview. The array after excluding all empty rows and/or columns from the outer edges of a range. |
| UNIQUE | (2021) The array of unique values in a list, table or cell range. |
| VLOOKUP | (XLOOKUP) The value in the same row after finding a matching value in the first column. |
| VSTACK | (2024) The array after putting multiple arrays on top of each other. |
| WRAPCOLS | (2024) The array transformed into multiple columns. |
| WRAPROWS | (2024) The array transformed into multiple rows. |
| 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 (2024) The array with just a specific number of columns. |
| CHOOSEROWS (2024) The array with just a specifiic number of rows. |
| COLUMN The column number of a cell reference. |
| COLUMNS The number of columns in a cell range or reference. |
| DROP (2024) The array without certain rows or columns. |
| EXPAND (2024) The array expanded or padded to specific dimensions. |
| FIELDVALUE (2024) The value in a particular field from a linked data type. |
| FILTER (2021) The array after filtering data that satisfies multiple conditions. |
| FORMULATEXT The formula from a particular cell. |
| GETPIVOTDATA The data obtained from a pivot table. |
| GROUPBY (365) Preview. The grouping of your data along one axis and aggregates the associated values. |
| HLOOKUP (XLOOKUP) The value in the same column after finding a matching value in the first row. |
| HSTACK (2024) The array after putting multiple arrays next to each other. |
| 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 (XMATCH) 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. |
| PIVOTBY (365) Preview. The grouping of your data along two axis and aggregates the associated values. |
| 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. |
| TAKE (2024) The intersection of specific rows and columns in an array. |
| TOCOL (2024) The array transformed into a single column. |
| TOROW (2024) The array transformed into a single row. |
| TRANSPOSE The array with its orientation changed. |
| TRIMRANGE (365) Preview. The array after excluding all empty rows and/or columns from the outer edges of a range. |
| UNIQUE (2021) The array of unique values in a list, table or cell range. |
| VLOOKUP (XLOOKUP) The value in the same row after finding a matching value in the first column. |
| VSTACK (2024) The array after putting multiple arrays on top of each other. |
| WRAPCOLS (2024) The array transformed into multiple columns. |
| WRAPROWS (2024) The array transformed into multiple rows. |
| 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