Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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 |