Syntax

INDIRECT(ref_text, a1)

Ref_text

A reference to a cell that contains an A1-style reference, an R1C1-style reference, a name defined as a reference, or a reference to a cell as a text string.

• If ref_text is not a valid cell reference, INDIRECT returns the #REF! error value.
• If ref_text refers to another workbook (an external reference), the other workbook must be open. If the source workbook is not open, INDIRECT returns the #REF! error value.
• If ref_text refers to a cell range outside the row limit of 1,048,576 or the column limit of 16,384 (XFD), INDIRECT returns a #REF! error.

Note:

This behavior is different from Excel versions earlier than Microsoft Office Excel 2007, which ignore the exceeded limit and return a value.

A1

A logical value that specifies what type of reference is contained in the cell ref_text.

• If a1 is TRUE or omitted, ref_text is interpreted as an A1-style reference.
• If a1 is FALSE, ref_text is interpreted as an R1C1-style reference.

Reference links

• INDIRECT function on office.microsoft.com
• Microsoft support page for usage of indirect function

Tag wiki credits to Microsoft Office documentation of function.