Skip to main content
Version: Streamsheets 2.4

INDIRECT

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

Syntax

=INDIRECT(Ref_Text, [R1C1_Style])

Arguments

NameDescription
Ref_TextA textual representation of a cell reference, cell range reference or a named cell.
R1C1_StyleOptional. If set to FALSE the given Ref_Text is interpreted as R1C1-style reference. Default is TRUE.

Return Value

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().

Example

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