Formula Overview / Functions in a Formula / Categories of Functions / Lookup Functions
Lookup Functions

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.