It returns a formula as a string.
The syntax of the function is the following:
INDIRECT(ref_text, [a1])
ref_text: A reference to a cell that contains an A1-style reference, an R1C1-style reference, a name defined as a reference, or a reference to a cell as a text string. If ref_text is not a valid cell reference, it returns the #REF! error value.
[a1]: Optional. If it is true (default) the ref_text is an A1-style reference. If it is false it is an R1C1-style reference.
Click on the button to practice using this function, with the help of our Online Assessment Tool:
Here is an example of how to use the INDIRECT function:
Enter the proper function in the G7 cell to display the reference value of the I7 cell.