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.