Kornilios Ampatzis/ May 2, 2019/ Functions

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:

Practice

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.

Share this Post