Referencing a cell in another sheet through the use of variables

  • Thread starter Thread starter JJ
  • Start date Start date
J

JJ

Hi,

I have a cell which refers to a cell in a different sheet like the
following:

='SheetB'!N5

Now, N is a variable which is the content of another cell (say H10),
and 5 is the actual row of the cell.
I am trying to use string concat so that the cell can display the
result of 'SheetB'!(Content of H10)(Row) but I am not having much
luck.

Which formula should I create ?

Thanks/Brgds
João
 
I think:

If H10 contains N5, then:
=indirect("'sheetb'!"&h10)

If H10 contained N, then:
=indirect("'sheetb'!"&h10&"5")

You could even refer to a different cell for all those pieces:

=indirect("'" & x99 & "'!" & z1000 & w1234)
 
Back
Top