Reference to a sheet name throught text

[ecelaras]

Hello!!

I would like to refer to a sheet name through another cell :

=name-of-sheet-in near-cell!A3267


Could you please help


Thank you

[XOR LX]

Hi,

Assuming the cell which contains your desired sheet name is B1:

=INDIRECT("'"&B1&"'!A3267")

You may need to make amendments to the format of e.g. the quotation marks "" if you paste this formula into a non-English version of Excel.

Regards

[ecelaras]

Thanks a Lot XOR LX

[XOR LX]

You're welcome.

[ecelaras]

I would Like to add something to my former question ....

If I have to columnes I would like from the first to get the name of the sheet and from the second the cell .

ex. =columnA!'columnB'

[XOR LX]

Hi,

Can you give an example with actual cell references (e.g. A1, B1) rather than "columnA" and "columnB"?

Regards

[ecelaras]

ok

a10=g3
b10=10

what i would like is ='10'!g3

but values taken from cell a10 and b10 so as when i drag it to change

This formula is also good for me =INDIRECT("'"&B1&"'!A3267") but i would like as I drag it to the right the b1 remain steady and 3267 to increase !!!

[XOR LX]

Ok,

Try:

=INDIRECT("'"&B10&"'!"&A10)

Regards

[ecelaras]

ok that is good but how could I drag it right and a10 becomes a11,a12 etc

[ecelaras]

Ok i got it I just copied and transposed a column


Thanks again XOR LX

[XOR LX]

You're welcome