Excel Lookup & Reference Functions
| Function | Description |
|---|---|
| ADDRESS | |
| AREAS | |
| CHOOSE | |
| CHOOSECOLS | |
| CHOOSEROWS | |
| COLUMN | |
| COLUMNS | |
| DROP | |
| EXPAND | |
| FIELDVALUE | |
| FILTER | |
| FORMULATEXT | |
| GETPIVOTDATA | |
| HLOOKUP | |
| HSTACK | |
| HYPERLINK | |
| INDEX | |
| INDIRECT | |
| LOOKUP | |
| MATCH | |
| OFFSET | |
| ROW | |
| ROWS | |
| RTD | |
| SORT | |
| SORTBY | |
| TAKE | |
| TOCOL | |
| TOROW | |
| TRANSPOSE | |
| UNIQUE | |
| VLOOKUP | |
| VSTACK | |
| WRAPCOLS | |
| WRAPROWS | |
| XLOOKUP | |
| XMATCH |