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
CHOOSE | Show a value or perform an action based on a choice |
HLOOKUP | Return a value from a table based on a value located anywhere in the first row |
INDEX | Return a value based on column no. and row no. |
INDEX + MATCH | Like HLOOKUP/VLOOKUP without being constrained to the first row/column |
MATCH | Return the position of a value in a list |
VLOOKUP | Return a value from a table based on a value located anywhere in the first column |