INDIRECT Function - Excel Scholar

INDIRECT Function Explained

The INDIRECT function in Microsoft Excel is used to return a reference to a range. It takes a text string as an argument and returns a reference specified by a text string. It can be used to create a dynamic reference to a cell, range of cells, or named range. It can also be used to create a reference to a worksheet that is different from the one that contains the INDIRECT function.

INDIRECT Function Syntax

INDIRECT(ref_text, [a1])

ref_text: A reference to a cell or range of cells. This can be a string of text, a cell reference, or a range of cells.
[a1]: (Optional) A logical value that specifies what type of reference is contained in the ref_text argument. If TRUE or omitted, ref_text is interpreted as an A1-style reference. If FALSE, ref_text is interpreted as an R1C1-style reference.