INDIRECT converts a string to a cell or range
Use INDIRECT to convert a string representation of a cell or range address to a reference to the cell or range. Table 11 contains examples accessing data as shown in Error: Reference source not found.
Table 11. Examples using INDIRECT.
Example
| Comment
|
INDIRECT("A2")
| Return cell A2, which contains Bob.
|
INDIRECT(G1)
| If Cell G1 contains the text A2, then this returns Bob.
|
SUM(INDIRECT("B1:B5"))
| Return the sum of the range B1:B5, which is 194.
|
INDIRECT(ADDRESS(2; 1))
| Returns the contents of cell $A$2, which is Bob.
|