INDIRECT

Returns the value of the reference specified by a text string.

Syntax

=INDIRECT(RefText, [R1C1Style])

Arguments

Name	Type	Description
RefText	String	A textual representation of a cell reference, cell range reference or a named cell.
R1C1Style (optional)	Boolean	If set to FALSE the given RefText is interpreted as R1C1-style reference. Default value: TRUE

Return

Type	Description
Number	The value at specified reference or #REF! if reference could not be created. Referencing to an indirect() function will result in handing over the reference build with the indirect cell not handing over the value represented by indirect().

Examples

Formula	Result	Comment
=INDIRECT("A1")	10	Returns the value of cell A1
=INDIRECT("A" & A5)	42	Assuming that A5 contains the value 4 the result represents the value of cell A4