Lookup and reference functions
| English | Description |
|---|---|
| ADDRESS | Returns a reference as text to a single cell in a worksheet |
| AREAS | Returns the number of areas in a reference |
| CHOOSE | Chooses a value from a list of values |
| COLUMN | Returns the column number of a reference |
| COLUMNS | Returns the number of columns in a reference |
| FILTER | Filters a range of data based on criteria you define |
| FORMULATEXT | Returns the formula at the given reference as text |
| GETPIVOTDATA | Returns data stored in a PivotTable report |
| HLOOKUP | Looks in the top row of an array and returns the value of the indicated cell |
| HYPERLINK | Creates a shortcut or jump that opens a document stored on a network server, an intranet, or the Internet |
| INDEX | Uses an index to choose a value from a reference or array |
| INDIRECT | Returns a reference indicated by a text value |
| LOOKUP | Looks up values in a vector or array |
| MATCH | Looks up values in a reference or array |
| OFFSET | Returns a reference offset from a given reference |
| ROW | Returns the row number of a reference |
| ROWS | Returns the number of rows in a reference |
| RTD | Retrieves real-time data from a program that supports COM automation |
| SORT | Sorts the contents of a range or array |
| SORTBY | Sorts the contents of a range or array based on the values in a corresponding range or array |
| TRANSPOSE | Returns the transpose of an array |
| UNIQUE | Returns a list of unique values in a list or range |
| VLOOKUP | Looks in the first column of an array and moves across the row to return the value of a cell |
| XLOOKUP | 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 | Returns the relative position of an item in an array or range of cells |