Manuals/calci/INDIRECT
Jump to navigation
Jump to search
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
| Column1 | Column2 | Column3 | Column4 | |
| Row1 | SMITH | |||
| Row2 | TABLE3!$B$2 | |||
| Row3 | SMITH | |||
| Row4 | ||||
| Row5 | ||||
| Row6 |
