How to use indirect function?

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!