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.
TRIMRANGE	Removes empty rows or columns around a cell range or table.
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.