|
<< Click to Display Table of Contents >> INDIRECT (create reference from text) |
Syntax:
INDIRECT(Text [, Mode])
Description:
This returns a cell reference from the specified text.
For example, the specified Text can contain a fixed cell address (e.g., "C1") or variable references that are combined from the contents of one or more cells.
The optional logical value Mode specifies the format of the given cell address:
TRUE or omitted: Normal cell address in A1 notation (columns are labeled alphabetically and rows numerically)
FALSE: Cell address in the R1C1 notation (columns and rows are labeled numerically; an alternative type of cell addressing supported only by Microsoft Excel)
Examples:
If cell C1 contains the text Flower
INDIRECT("C1") returns a reference to cell C1 and the result: Flower
If cell C1 contains the text E5
and cell E5 the text Flower
INDIRECT(C1) returns a reference to cell E5 and the result: Flower
If cell C1 contains the text E
and cell C2 the text 5
and cell E5 the text Flower
INDIRECT(C1&C2) returns a reference to cell E5 and the result: Flower
If cell E5 contains the text Flower
INDIRECT("E"&5") returns a reference to cell E5 and the result: Flower
If cell C1 contains the text 5
and E5 the text Flower
INDIRECT("E"&C1) returns a reference to cell E5 and the result: Flower
See also: