Using the Excel INDIRECT Function
SummaryThe Excel INDIRECT function is used to creates a reference specified by a text string. This function is useful if you need to convert a reference assembled as text into a proper reference.
Syntax=INDIRECT (ref_text, [a1])
Syntax BreakdownRef Text
Required. A reference to a cell. The cell may contain an A1-style reference, an R1C1-style reference, a name defined as a reference, or a reference to a cell as a test string. The function returns the #REF! error if ref_text is not a valid cell reference.
Ref_text can refer to another workbook. However, the other workbook must be open of the function will return the #REF! error.
The function also returns the #REF! error if ref_text is outside of the row limit (1,048,576) or the column limit (16,384).
Optional. Logical value used to specify what type of reference is contained in the ref_text cell.
If A1 is TRUE or blank, ref_text is interpreted as an A1-style reference.
If A1 is FALSE, ref_text is interpreted as an R1C1-style reference.