The functions that relate to referencing and finding other parts of the spreadsheet are:
| ADDRESS | AREAS | CHOOSE | COLUMN |
| COLUMNS | FORMULATEXT | HLOOKUP | HYPERLINK |
| INDEX | INDIRECT | LOOKUP | MATCH |
| OFFSET | ROW | ROWS | RTD |
| TRANSPOSE | VLOOKUP | XLOOKUP | XMATCH |
Return to the list of Categories of Functions.