Lookup and Reference Functions
ADDRESS function
Returns a text representation of a cell address.
CHOOSE function
Returns a value from a list of values based on a specified index (position).
CHOOSECOLS function
Returns columns from an array or reference.
CHOOSEROWS function
Returns rows from an array or reference.
COLUMN function
Returns the column number of a cell.
COLUMNS function
Returns the number of columns in a cell reference.
DROP function
Drops rows or columns from the start or end of an array.
EXPAND function
Expands a range of data (array) by adding rows and columns.
FILTER function
Filters a range of data and returns the results that match the criteria you specify.
FORMULATEXT function
Returns a formula as a string.
HLOOKUP function
Performs a horizontal search for a value in the top row of a table or an array and returns the value in the same column based on a specified row index number.
HSTACK function
Horizontally stacks arrays into one array.
HYPERLINK function
The HYPERLINK function creates a shortcut that jumps to another location in the current workbook or opens a document stored on a network server, an intranet, or the Internet.
INDEX function
The INDEX function returns a value within a range of cells on the base of a specified row and column number.
INDIRECT function
The INDIRECT function returns the reference to a cell based on its string representation.
LOOKUP function
The LOOKUP function returns a value from a selected range (row or column containing the data in ascending order).
MATCH function
The MATCH function returns a relative position of a specified item in a range of cells.
OFFSET function
The OFFSET function returns a reference to a cell displaced from the specified cell (or the upper-left cell in the range of cells) to a certain number of rows and columns.
ROW function
The ROW function returns the row number of a cell reference.
ROWS function
The ROWS function returns the number of rows in a cell reference.
SORT function
The SORT function sorts a range of data or an array and returns the sorted array.
SORTBY function
The SORTBY function sorts a range of data or an array based on the values in a corresponding range or array.
TAKE function
The TAKE function returns rows or columns from array start or end.
TOCOL function
The TOCOL function returns the array as one column.
TOROW function
The TOROW function returns an array as one row.
TRANSPOSE function
The TRANSPOSE function converts columns into rows and rows into columns.
UNIQUE function
The UNIQUE function returns a list of unique values from the specified range.
VLOOKUP function
The VLOOKUP function performs a vertical search for a value in the left-most column of a table or an array and returns the value in the same row from a specified column.
VSTACK function
The VSTACK function vertically stacks arrays into one array.
WRAPCOLS function
The WRAPCOLS function wraps a row or column vector by columns after a specified number of values.
WRAPROWS function
The WRAPROWS function wraps a row or column vector by rows after a specified number of values.
XLOOKUP function
The XLOOKUP function searches for a specific item by row, both horizontally and vertically, and returns the result in another column.
XMATCH function
The XMATCH function returns the relative position of an item in an array.