Contents of a cell refer to sheet name
 

Hello there

I would like to do something like this:

in sheet1 the value of cell A1="sheet2"
in sheet1 the formula in cell B1 should be something like:

='A1!'C5

so that it will look in sheet2 because that's the value in A1.

Doesn't work, does it?

Thanks

Peter

Contents of a cell refer to sheet name
 

Hi
try in cell B1
=INDIRECT("'" & A1 & "'!C5")

--
Regards
Frank Kabel
Frankfurt, Germany


Audio_freak wrote:
Hello there

I would like to do something like this:

in sheet1 the value of cell A1="sheet2"
in sheet1 the formula in cell B1 should be something like:

='A1!'C5

so that it will look in sheet2 because that's the value in A1.

Doesn't work, does it?

Thanks

Peter

Contents of a cell refer to sheet name
 

=Indirect("'" & A1 & "'!C5")


the single quote is to the left of the exclamation point.

--
Regards,
Tom Ogilvy

"Audio_freak" wrote in message
. 2.2...
Hello there

I would like to do something like this:

in sheet1 the value of cell A1="sheet2"
in sheet1 the formula in cell B1 should be something like:

='A1!'C5

so that it will look in sheet2 because that's the value in A1.

Doesn't work, does it?

Thanks

Peter

Contents of a cell refer to sheet name
 

"Tom Ogilvy" wrote in
:

Indirect("'" & A1 & "'!C5")



That works fellows. Thanks very much!

P