INDIRECT function

INDIRECT returns the reference specified by a text string. Use this function if you want a formula to always refer to a particular cell address, regardless of the contents of the cell after rows or cells have been moved or deleted. This function can also be used to return the area of a corresponding string.




=INDIRECT(A1) equals 100 if cell A1 contains C108 as a reference and cell C108 contains a value of 100.

=SUM(INDIRECT("a1:" & ADDRESS(1,3))) totals the cells in the area of A1 up to the cell. The cell address is defined by row 1 and column 3. Therefore, area A1:C1 is totaled.

Trademarks | IBM Connections wiki