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 |