On Thu, 30 Jul 2009 10:12:01 -0700, HebbeLille
wrote:

Hi!
Can anyone please guide me on how to change part of cell reference in this
formula:
=INDIRECT("'[" & $A$19 & "]Sheet1'!$B$2")

The formula is in Sheet2, and I would like to change the reference $B$2 with
the value from cell H1 in sheet2.
I have tried with =INDIRECT("'[" & $A$19 & "]Sheet1'!$B$(=INDIRECT( H1)"),
but it gives error #REF.

Any help would be appreciated.


If it is only the 2 in the $B$2 that should be replaced, try this:

=INDIRECT("'[" & $A$19 & "]Sheet1'!$B$"&H1)

Hope this helps / Lars-Åke