Skip to Content

INDIRECT

Returns the reference specified by a text string

Syntax

INDIRECT(ref_text, [a1])

Parameters

  • ref_text: Required. A reference to a cell that contains an A1-style or R1C1-style reference, a name defined as a reference, or a reference to a cell as a text string
  • a1: Optional. A logical value: TRUE for A1-style (default), FALSE for R1C1-style

Example

=INDIRECT("A" & B1)
Returns: ReferenceSince: Excel 2003