Returns a cell reference specified by a string.
Sample Usage
INDIRECT("C5")
INDIRECT("R2C3",FALSE)
Syntax
INDIRECT(text, [A1_notation])
- text - A cell reference, written as a string.
- A1_notation - [OPTIONAL] A logical value that determines whether the cell reference is in A1 notation or in R1C1 notation.
Examples
INDIRECT("C5") returns the value of the reference in cell C5. If C5 has a text string that reads C7, the contents of cell C7 will be returned by the INDIRECT("C5") function.