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,