|
<< Click to Display Table of Contents >> INDIRECT (create reference from text) |
Syntax:
INDIRECT(Text [, Mode])
Description:
Returns a cell reference from the specified text string.
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 argument Mode specifies the format of the cell address to be evaluated:
TRUE or not specified: Normal cell address in A1 style (columns are labeled alphabetically and rows numerically)
FALSE: Cell address in the R1C1 style (columns and rows are labeled numerically; an alternative way of cell addressing supported only by Microsoft Excel)
Some examples:
If cell C1 contains the text string Flower
INDIRECT("C1") returns a reference to cell C1 and the result: Flower
If cell C1 contains the text string E5
and cell E5 the text string Flower
INDIRECT(C1) returns a reference to cell E5 and the result: Flower
If cell C1 contains the text string E
and cell C2 the text string 5
and cell E5 the text string Flower
INDIRECT(C1&C2) returns a reference to cell E5 and the result: Flower
If cell E5 contains the text string Flower
INDIRECT("E"&5") returns a reference to cell E5 and the result: Flower
If cell C1 contains the text string 5
and E5 the text string Flower
INDIRECT("E"&C1) returns a reference to cell E5 and the result: Flower
See also: