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

OFFSET