Shulou(Shulou.com)06/03 Report--

This article is to share with you about how to use the indirect function, the editor thinks it is very practical, so I share it with you to learn. I hope you can get something after reading this article.

The indirect function returns the reference specified by the text string. The syntax is "INDIRECT (ref_text, [A1])", "Ref_text" is a reference to a cell, and "A1" is a logical value indicating the type of reference contained in cell "ref_text".

The syntax is:

INDIRECT (ref_text, [A1])

Ref_text is a reference to a cell that can contain a reference to an A1-style, a reference to an R1C1-style, a name defined as a reference, or a reference to a text string cell. If ref_text is not a legal reference to a cell, the function INDIRECT returns the error value # REF! Or # NAME?

If ref_text is a reference to another workbook (an external reference), the workbook must be opened. If the source workbook is not open, the function INDIRECT returns the error value # REF!.

A1 is a logical value that indicates the type of reference contained in cell ref _ text.

If A1 is TRUE or omitted, ref_text is interpreted as a reference to A1-style.

If A1 is FALSE,ref_text, it is interpreted as a reference to R1C1-style.

The above is how to use the indirect function, the editor believes that there are some knowledge points that we may see or use in our daily work. I hope you can learn more from this article. For more details, please follow the industry information channel.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.