Important: Try using the new XLOOKUP function, an improved version of VLOOKUP that works in any direction and returns exact matches by default, making it easier and more convenient to use than its predecessor.
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.
Description
Returns a reference as text to a single cell in a worksheet
Returns the number of areas in a reference
Chooses a value from a list of values
Returns the specified columns from an array
Returns the specified rows from an array
Returns the column number of a reference
Returns the number of columns in a reference
Excludes a specified number of rows or columns from the start or end of an array
Expands or pads an array to specified row and column dimensions
Filters a range of data based on criteria you define
Returns the formula at the given reference as text
Returns data stored in a PivotTable report
Looks in the top row of an array and returns the value of the indicated cell
Appends arrays horizontally and in sequence to return a larger array
Creates a shortcut or jump that opens a document stored on a network server, an intranet, or the Internet
Uses an index to choose a value from a reference or array
Returns a reference indicated by a text value
Looks up values in a vector or array
Looks up values in a reference or array
Returns a reference offset from a given reference
Returns the row number of a reference
Returns the number of rows in a reference
Retrieves real-time data from a program that supports COM automation
Sorts the contents of a range or array
Sorts the contents of a range or array based on the values in a corresponding range or array
Returns a specified number of contiguous rows or columns from the start or end of an array
Returns the array in a single column
Returns the array in a single row
Returns the transpose of an array
Returns a list of unique values in a list or range
Appends arrays vertically and in sequence to return a larger array
Looks in the first column of an array and moves across the row to return the value of a cell
Wraps the provided row or column of values by columns after a specified number of elements
Wraps the provided row or column of values by rows after a specified number of elements
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.
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.
