Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Function to Insert Text Into a Formula
I need a way to get text from a cell put into a function such that the text
fills in the name of the worksheet to look for the data in. i.e. I want to look for cell B2 in worksheet test, then the next cell down I want to look for cell B2 in worksheet answer, etc but I don't want to have to modify the formula to input the worksheet name every time. I want a way for the worksheet name to be grabbed from an adjacent cell and populate the formula that already has the cell B2 in it. Thx. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Function to Insert Text Into a Formula
Assuming that you have the sheet names in A2, A3, A4 etc, put this
formula in B2: =INDIRECT("'"&A2&"'!B2") then copy down. The apostrophes enable you to have sheet names with spaces in. Hope this helps. Pete On Feb 20, 7:24*am, navel151 wrote: I need a way to get text from a cell put into a function such that the text fills in the name of the worksheet to look for the data in. i.e. I want to look for cell B2 in worksheet test, then the next cell down I want to look for cell B2 in worksheet answer, etc but I don't want to have to modify the formula to input the worksheet name every time. *I want a way for the worksheet name to be grabbed from an adjacent cell and populate the formula that already has the cell B2 in it. Thx. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Function to Insert Text Into a Formula
TY
"Pete_UK" wrote: Assuming that you have the sheet names in A2, A3, A4 etc, put this formula in B2: =INDIRECT("'"&A2&"'!B2") then copy down. The apostrophes enable you to have sheet names with spaces in. Hope this helps. Pete On Feb 20, 7:24 am, navel151 wrote: I need a way to get text from a cell put into a function such that the text fills in the name of the worksheet to look for the data in. i.e. I want to look for cell B2 in worksheet test, then the next cell down I want to look for cell B2 in worksheet answer, etc but I don't want to have to modify the formula to input the worksheet name every time. I want a way for the worksheet name to be grabbed from an adjacent cell and populate the formula that already has the cell B2 in it. Thx. . |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Function to Insert Text Into a Formula
You're welcome.
Pete On Feb 20, 5:26*pm, navel151 wrote: TY "Pete_UK" wrote: Assuming that you have the sheet names in A2, A3, A4 etc, put this formula in B2: =INDIRECT("'"&A2&"'!B2") then copy down. The apostrophes enable you to have sheet names with spaces in. Hope this helps. Pete On Feb 20, 7:24 am, navel151 wrote: I need a way to get text from a cell put into a function such that the text fills in the name of the worksheet to look for the data in. i.e. I want to look for cell B2 in worksheet test, then the next cell down I want to look for cell B2 in worksheet answer, etc but I don't want to have to modify the formula to input the worksheet name every time. *I want a way for the worksheet name to be grabbed from an adjacent cell and populate the formula that already has the cell B2 in it. Thx. .- Hide quoted text - - Show quoted text - |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I insert a formula in a cell,which contains some text | Excel Discussion (Misc queries) | |||
Insert text in a formula | Excel Worksheet Functions | |||
How to Insert function right on text values e.g. 0180001640 | Excel Worksheet Functions | |||
How to Insert function right on text values e.g. 0180001640 | Excel Worksheet Functions | |||
how do I insert a function that chooses between two text values? | Excel Worksheet Functions |