Referencing a cell in another sheet through the use of variables

[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

 

[Dave Peterson]

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)

 

[mrkt_rwnd]

=Indirect()?

= "text" & cellref & "text" & number