deepcalc
DocsINDIRECT

INDIRECT

View as markdown/docs/functions/indirect.md Ask Claude about this pageOpens Claude with this page's address

Returns reference specified by text string.

  • Excel: Not checked yet
  • Google Sheets: Not checked yet
  • Returns: Reference

Examples

=INDIRECT("B2")
B
2 4
Result 4
=INDIRECT("A" & ROW())
Result 0

Syntax

INDIRECT(ref_text, [a1])
ref_text
text required
a1
boolean optional

Errors

#REF!
=INDIRECT(A1:A3)
ADDRESSReturns a cell address as text from row and column numbers. AREASReturns the number of areas in a reference. HLOOKUPSearches first row and returns matching value. HYPERLINKThe text a link displays: clickability is the renderer's. INDEXReturns value at row and column in range. LOOKUPLooks up value in one-row or one-column range.