Manuals/calci/INDIRECT

INDIRECT(reference_text, ReferenceStyle)

where,

reference_text - represents a reference to a cell asa text string.

ReferenceStyle - is a logical value that specifies the type of reference contain in the cell reference_text.

If ReferenceStyle is true or omitted, reference_textis interpreted as an A1-style reference.

Returns the reference specified by a text string.

If reference_text is not a valid cell reference, INDIRECT returns #ERROR.

INDIRECT

Lets see an example in (Column1, Row3)

=INDIRECT(TABLE3!$B$2,TRUE)

INDIRECT returns SMITH.

Syntax

Remarks

Examples

Description