Excel Functions: Lookup & Reference
Find the list of all Excel function tutorials on the page Excel Functions.
Lookup & Reference Functions
CHOOSE | Displays a value or performs an action based on a choice. |
FILTER | Filters a range of cells based on defined criteria. |
INDEX | Returns a value from an array based on its coordinates. |
INDEX + MATCH | Combination similar to HLOOKUP/VLOOKUP without the constraint of the first row/column. |
HLOOKUP | Returns a value from an array based on a value in the first row. |
MATCH | Returns the position of a value in an array. |
SORT | Sorts the content of a range of cells or an array. |
SORTBY | Sorts the content of a range of cells or an array based on a range of cells or an array. |
UNIQUE | Returns the list of unique values from a range of cells or an array. |
VLOOKUP | Returns a value from an array based on a value in the first column. |
XLOOKUP | Searches for a value in an array then returns the corresponding value in the same position in a second array. |
XMATCH | Returns the position of a value in an array. |