INDIRECT
Description
INDIRECT returns the contents of the cell referenced by the specified cell.
Syntax
INDIRECT ( ref_text [, A1] )
Parameter |
Description |
ref_text |
A reference to a cell that references a third cell. If ref_text is not a valid reference, the error #REF! is returned. |
A1 |
The reference format. This argument must be TRUE() to represent an A1 reference format. The R1C1 reference format is not supported. |
Example
This function returns the contents of the cell that C1 references. If C1 contains "D1," then the contents of D1is returned:
INDIRECT(C1)
Also, see