indirect function help

[josh_m]

Basically I have a formula like this:
=INDIRECT($A1&"!B1")

this works just fine, but I would like to copy the formula down the column and get something like this:
=INDIRECT($A1&"!B2")
=INDIRECT($A1&"!B3")
=INDIRECT($A1&"!B4")

I will also need to copy the formula across the row to get this:
=INDIRECT($A1&"!C1"), =INDIRECT($A1&"!D1"), =INDIRECT($A1&"!E1")

Is this possible? thanks for your help!

 

[gramit]

You would have to set up a table where the column headings are the letters and row headings are the row numbers, and use these in the indirect function also.

e.g.

=INDIRECT($A$1 & B$10 & $A11)

 

[Aladin Akyurek]

Try...

=INDIRECT("'"&$A$1&"'!"&CELL("address",B1))