| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Use cell contents to build sheet reference
I have a worksheet that lists other worksheet names in column A. In column B,
I want to retrieve a value from the sheet listed in column A. For example, if the value in A1 is "MySheet" (without the quotes), then B1 should return the value of 'MySheet'!M20. I tried building the formula: ="='"&CELL("contents",A1)&"'!M20" But the cell just shows the formula I built as text, instead of the actual formula. Thanks for any help, ~ Horatio |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| cell contents from a reference | Excel Discussion (Misc queries) | |||
| Build a reference to another worksheet from cell values in currentsheet | Excel Worksheet Functions | |||
| Using cell value to build external reference | Excel Discussion (Misc queries) | |||
| Using a cells contents to reference a sheet. | Excel Worksheet Functions | |||
| Getting contents of a cell when cell reference is in the sheet | Excel Discussion (Misc queries) | |||
Threaded Mode
