Text from one cell in a formula in another
 

Is there a way to use the text in one cell (A3, for example) in a formula in
C3 to identify the sheet (in the same workbook) to look on for data?

I am looking for the value of cell C35 on the sheet named in A3.

Basically, this is what I think C3 needs to look like:

=(_textfromA3_!C35)

I cannot figure out how to tell it to do this with a formula that I can
paste in lots of cells.

Text from one cell in a formula in another
 

Try this:

=INDIRECT("'"&A3&"'!C35")


--
Biff
Microsoft Excel MVP


"Scooter" wrote in message
...
Is there a way to use the text in one cell (A3, for example) in a formula
in
C3 to identify the sheet (in the same workbook) to look on for data?

I am looking for the value of cell C35 on the sheet named in A3.

Basically, this is what I think C3 needs to look like:

=(_textfromA3_!C35)

I cannot figure out how to tell it to do this with a formula that I can
paste in lots of cells.

Text from one cell in a formula in another
 

I knew it was going to be embarassingly simple.

Works like a charm. Thanks.



"T. Valko" wrote:

Try this:

=INDIRECT("'"&A3&"'!C35")


--
Biff
Microsoft Excel MVP


"Scooter" wrote in message
...
Is there a way to use the text in one cell (A3, for example) in a formula
in
C3 to identify the sheet (in the same workbook) to look on for data?

I am looking for the value of cell C35 on the sheet named in A3.

Basically, this is what I think C3 needs to look like:

=(_textfromA3_!C35)

I cannot figure out how to tell it to do this with a formula that I can
paste in lots of cells.

Text from one cell in a formula in another
 

You're welcome. Thanks for the feedback!

--
Biff
Microsoft Excel MVP


"Scooter" wrote in message
...
I knew it was going to be embarassingly simple.

Works like a charm. Thanks.



"T. Valko" wrote:

Try this:

=INDIRECT("'"&A3&"'!C35")


--
Biff
Microsoft Excel MVP


"Scooter" wrote in message
...
Is there a way to use the text in one cell (A3, for example) in a
formula
in
C3 to identify the sheet (in the same workbook) to look on for data?

I am looking for the value of cell C35 on the sheet named in A3.

Basically, this is what I think C3 needs to look like:

=(_textfromA3_!C35)

I cannot figure out how to tell it to do this with a formula that I can
paste in lots of cells.