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.
--
HebbeLille