Referencing a cell in another sheet through the use of variables


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
 
Ad

Advertisements

D

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)
 
Ad

Advertisements


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top