Lookup and reference functions reference

To get detailed information about a function, click its name in the first column.

Note: Version markers indicate the version of Excel a function was introduced. These functions aren't available in earlier versions. For example, a version marker of 2013 indicates that this function is available in Excel 2013 and all later versions.

Function	Description
ADDRESS function	Returns a reference as text to a single cell in a worksheet
AREAS function	Returns the number of areas in a reference
CHOOSE function	Chooses a value from a list of values
COLUMN function	Returns the column number of a reference
COLUMNS function	Returns the number of columns in a reference
FILTER function	Filters a range of data based on criteria you define
FORMULATEXT function	Returns the formula at the given reference as text
GETPIVOTDATA function	Returns data stored in a PivotTable report
HLOOKUP function	Looks in the top row of an array and returns the value of the indicated cell
HYPERLINK function	Creates a shortcut or jump that opens a document stored on a network server, an intranet, or the Internet
INDEX function	Uses an index to choose a value from a reference or array
INDIRECT function	Returns a reference indicated by a text value
LOOKUP function	Looks up values in a vector or array
MATCH function	Looks up values in a reference or array
OFFSET function	Returns a reference offset from a given reference
ROW function	Returns the row number of a reference
ROWS function	Returns the number of rows in a reference
RTD function	Retrieves real-time data from a program that supports COM automation
SORT function	Sorts the contents of a range or array
SORTBY function	Sorts the contents of a range or array based on the values in a corresponding range or array
TRANSPOSE function	Returns the transpose of an array
UNIQUE function	Returns a list of unique values in a list or range
VLOOKUP function	Looks in the first column of an array and moves across the row to return the value of a cell
XLOOKUP function	Searches a range or an array, and returns an item corresponding to the first match it finds. If a match doesn't exist, then XLOOKUP can return the closest (approximate) match.
XMATCH function	Returns the relative position of an item in an array or range of cells.

Important: The calculated results of formulas and some Excel worksheet functions may differ slightly between a Windows PC using x86 or x86-64 architecture and a Windows RT PC using ARM architecture. Learn more about the differences.

Excel functions (by category)

Excel functions (alphabetical)