The indirect function is used to return a reference specified by a text string. The syntax is: "INDIRECT(ref_text,[a1])"; "Ref_text" is a reference to the cell; "a1" is a logical value indicating the type of reference contained in the cell "ref_text".
The indirect function is used to return the reference specified by a text string
The syntax is:
INDIRECT(ref_text,[a1])
Ref_text is a reference to the cell. This cell can contain A1-style references, R1C1-style of a reference, a name defined as a reference, or a reference to a text string cell. If ref_text is not a valid cell reference, the INDIRECT function returns the error value #REF! or #NAME?.
If ref_text is a reference to another workbook (external reference), the workbook must be opened. If the source workbook is not open, the INDIRECT function returns the #REF! error value.
a1 is a logical value indicating the type of reference contained in 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.
For more related knowledge, please visit PHP Chinese website! !
The above is the detailed content of How to use indirect function?. For more information, please follow other related articles on the PHP Chinese website!