Returns the reference specified by the text string. This function evaluates the reference immediately and displays its contents. When a reference to a cell in a formula needs to be changed, while
Without changing the formula itself, use the function INDIRECT.
grammar
INDIRECT(ref_text,a1)
Ref_text is a reference to a cell, which can contain an A1- style reference, an R1C1- style reference, a name defined as a reference, or a pair of text
A reference to a string cell. If ref_text is not a valid cell reference, the function INDIRECT returns the #REF! Error value. .
■ If ref_text is a reference to another workbook (external reference), that workbook must be opened.
If the source workbook is not open, the function INDIRECT 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 a reference to A1- style.
■ If a1 is FALSE, ref_text is interpreted as a reference to the R1C1- style.
I want to create a clean, concise and efficient office reference manual, in order to maintain a good reference experience, I did not add any third-party advertisements in my blog, of course, if you are willing, you can watch the following video, it can bring me some income, so that I can better maintain the server to provide higher quality service, thank you for your help and support.
You can choose any link below to watch my videos and I will earn some money to strengthen the site and resist DDOS attacks that may happen at any time, thank you for your support!
(Please note: Please do not maliciously click on links or video ads to increase invalid traffic, as this can result in lower or no revenue.)
Learn to consult the manual video
(Will be released in the later period with the consult the manual article, please pay attention.)
My Febspot video list (Learn after-school relaxation videos)
https://suu.us/sponsor
My Febspot video home page
https://www.febspot.com/leet4477/