Try the below (row reference from Sheet2 H1)

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

If this post helps click Yes
---------------
Jacob Skaria


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