: 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.
: 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 |
|---|---|
|
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. |
: 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.
