| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula & text in one cell | Excel Discussion (Misc queries) | |||
| text and formula in the same cell - how do I format this cell?? | Excel Discussion (Misc queries) | |||
| Excel Formula if cell is empty then no if text in cell then yes | Excel Worksheet Functions | |||
| Text in Cell as Formula | Excel Discussion (Misc queries) | |||
| match cell text with text in formula | Excel Worksheet Functions | |||
Linear Mode
