Lookup and Reference Functions

On this page, you'll find the most commonly used lookup and reference functions, each demonstrated in a simple example.

Lookup and Reference Functions

CHOOSEShow a value or perform an action based on a choice
HLOOKUPReturn a value from a table based on a value located anywhere in the first row
INDEXReturn a value based on column no. and row no.
INDEX + MATCHLike HLOOKUP/VLOOKUP without being constrained to the first row/column
MATCHReturn the position of a value in a list
VLOOKUPReturn a value from a table based on a value located anywhere in the first column