Hi zleyphox,
INDIRECT returns the reference specified by a "text string".
If you try:
A1:1
A2:=INDIRECT($A$1)
Excel will return a #REF! error because "1" is not a valid reference to a cell.
Try it this way:
=INDIRECT("$A$1")
and it should work.
Cheers,
|