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

Return to the list of Categories of Functions.