Excel Functions: Lookup & Reference

Find the list of all Excel function tutorials on the page Excel Functions.

Lookup & Reference Functions

CHOOSEDisplays a value or performs an action based on a choice.
FILTERFilters a range of cells based on defined criteria.
INDEXReturns a value from an array based on its coordinates.
INDEX + MATCHCombination similar to HLOOKUP/VLOOKUP without the constraint of the first row/column.
HLOOKUPReturns a value from an array based on a value in the first row.
MATCHReturns the position of a value in an array.
SORTSorts the content of a range of cells or an array.
SORTBYSorts the content of a range of cells or an array based on a range of cells or an array.
UNIQUEReturns the list of unique values from a range of cells or an array.
VLOOKUPReturns a value from an array based on a value in the first column.
XLOOKUPSearches for a value in an array then returns the corresponding value in the same position in a second array.
XMATCHReturns the position of a value in an array.