INDIRECT function

The INDIRECT function is one of the lookup and reference functions. It is used to return the reference to a cell based on its string representation.

Syntax

INDIRECT(ref_text, [a1])

The INDIRECT function has the following arguments:

Argument	Description
ref_text	A reference to a cell specified as a text string.
a1	A representation style. It is an optional logical value: TRUE or FALSE. If it is set to TRUE or omitted, the function will analyse ref_text as an A1-style reference. If FALSE, the function will interpret ref_text as an R1C1-style reference.

Notes

Please note that this is an array formula. To learn more, please read the Insert array formulas article.

How to apply the INDIRECT function.

Examples

The figure below displays the result returned by the INDIRECT function.