INDIRECT

Returns the reference represented by the specified text.

Syntax

INDIRECT( Text ref, [Logical a1 = TRUE] ) → Reference

Parameters

ref

Required. The string representation of a reference.

a1

Optional. A flag indicating how to interpret ref. If omitted, a1 is assumed to be TRUE.

Remarks

If a1 is TRUE, the ref argument is interpreted as an A1-style reference; otherwise, ref is interpreted as a R1C1-style reference. If ref is not a valid reference, the function returns the #REF! error value.

Example

Formula

=INDIRECT("A1")
=INDIRECT("R[1]C5",FALSE)

See Also

Function Reference
OFFSET Function