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