Lookup and Referent Functions

ADDRESS

The ADDRESS function returns a cell address as text, based on a given row and column number.

AREAS

The AREAS function in Microsoft Excel returns the number of areas in a reference.

CHOOSE

The CHOOSE function in Excel is used to select one of a number of values based on an index number.

CHOOSECOLS

The CHOOSECOLS function allows you to select columns from a range of cells. It returns an array of the selected column numbers.

CHOOSEROWS

The CHOOSEROWS function returns an array of rows from a list based on a criteria.

COLUMN

The COLUMN function is an Excel function that returns the column number of a given cell reference.

COLUMNS

COLUMNS is a function in Microsoft Excel that returns the number of columns in a given array or reference.

DROPDOWN

The DROPDOWN function creates a dropdown list in a cell.

EXPAND

The EXPAND function is used to expand a range of cells from a single cell.

FILTER

The FILTER function is used to filter a range of data based on supplied criteria. It returns a subset of data that meets the criteria.

FORMULATEXT

The FORMULATEXT function is used to return the formula in a cell as text.

GETPIVOTDATA

The GETPIVOTDATA function in Excel is used to retrieve data stored in a PivotTable. It is used to reference data stored in a PivotTable by using a standard cell reference.

HLOOKUP

HLOOKUP is an Excel function used to look up and retrieve data from a row in a table. It searches for a value in the top row of the table and returns the corresponding value in the same column from another row.

HSTACK

HSTACK is an Excel function that allows users to combine two or more arrays into one single array

HYPERLINK

The HYPERLINK function creates a shortcut that jumps to a specific location in the current workbook, opens a document stored on a network server, or opens a web page on the Internet.

INDEX

The INDEX function returns a value or reference of the cell at the intersection of a particular row and column within a range.

INDIRECT

The INDIRECT function returns a reference to a range. It is useful when you want to convert a text string into a valid reference.

LOOKUP

The LOOKUP function is used to look up a value in a row or column of data. It can be used to look up a value either vertically (in a column) or horizontally (in a row).

MATCH

MATCH is a function in Excel that looks for a specified item in a range of cells and returns the relative position of that item in the range.

OFFSET

The OFFSET function returns a reference to a range that is a specified number of rows and columns from a given reference cell.

ROW

The ROW function returns the row number of a cell reference.

ROWS

The ROWS function returns the number of rows in a given array or range.

RTD

The RTD function in Excel is used to retrieve real-time data from a program that supports COM automation.

SORT

The SORT function in Excel allows users to sort a range of data by one or more columns or rows in either ascending or descending order.

SORTBY

The SORTBY function sorts a range of data based on one or more columns.

TAKE

TAKE is an Excel function that returns a specified number of characters from the start of a text string.

TOCOL

The TOCOL function returns the column number of a given cell reference.

TOROW

The TOROW function returns the row number of a reference.

TRANSPOSE

The TRANSPOSE function in Excel is used to transpose a range of cells from vertical to horizontal or vice versa.

UNIQUE

The UNIQUE function in Excel is used to return a list of unique values from a list or range.

VLOOKUP

VLOOKUP is an Excel function used to look up and retrieve data from a specific column in a table. It searches for a value in the leftmost column of a table and returns a value in the same row from another column.

VSTACK

The VSTACK function in Excel is used to stack two or more vertical ranges of data on top of each other.

WRAPCOLS

The WRAPCOLS function in Microsoft Excel is used to wrap the contents of a cell across multiple columns.

WRAPROWS

WRAPROWS is a Microsoft Excel function that allows you to wrap text in a cell to multiple lines. This is useful when you have a long text string that needs to be displayed in a cell.

XLOOKUP

XLOOKUP is an Excel function that looks for a value in the first column of a table array and returns the corresponding value from another column in the same row.

XMATCH

XMATCH function returns the position of a value in a given array that matches a specified value in a specified order.