INDIRECT

See also A-Z Spreadsheet Function List

Description Returns the contents of the cell referenced by the specified cell.

Syntax INDIRECT(ref_text [, a1])

ref_text is a reference to a cell that references a third cell. If ref_text is not a valid reference, #REF! is returned.

a1 is the reference format. This argument must be TRUE() to represent an A1 reference format; Formula One does not support the R1C1 reference format.

See Also OFFSET function

Example INDIRECT(C1) returns the contents of the cell that C1 references. If C1 contains “D1”, the contents of D1 is returned by INDIRECT.