Pages

Saturday, February 5, 2011

Convert String to Reference in Excel

Convert String to Reference

The INDIRECT worksheet function is a useful tool for creating cell or range references "on the fly", as a formula is evaluated, rather than "hard coding" them into the formula.

In its simplest usage, the INDIRECT function allows you to put the address of one cell in another, and get data from the the first cell by referencing the second. For example, if cell A1 has the value "C3", then =INDIRECT(A1) will return the value in C3