| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Can a sheet be referenced by a value in a cell?
If I'm in sheet "Main" and the value of A1 is "DEV",
is there way to reference the DEV sheet by the value that is in a cell, in this case the value in A1? For example, in sheet "Main" A1 has "DEV", in cell A2, I do something like =Valueof(A1)!D13 I'd like to reference cell D13 in sheet "DEV", but I don't want to hard-code "DEV" or any other value in A1. Can this be done? Thanks |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Can a sheet be referenced by a value in a cell?
=INDIRECT("'"&A1&"'!D13")
"Reddiance" wrote: If I'm in sheet "Main" and the value of A1 is "DEV", is there way to reference the DEV sheet by the value that is in a cell, in this case the value in A1? For example, in sheet "Main" A1 has "DEV", in cell A2, I do something like =Valueof(A1)!D13 I'd like to reference cell D13 in sheet "DEV", but I don't want to hard-code "DEV" or any other value in A1. Can this be done? Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Creating a master sheet referenced to multiple worksheets | Excel Discussion (Misc queries) | |||
| The absolute referenced cell does not move when source cell moves | Excel Worksheet Functions | |||
| Lookup funtion referenced from another sheet. | Excel Worksheet Functions | |||
| Automate a date referenced in a formula pointing to another sheet | Excel Worksheet Functions | |||
| How do I double click a cell and jump to cell's referenced cell | Excel Discussion (Misc queries) | |||
Linear Mode
