| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Use a range value in place of sheet name
Tried searching for this but I guess I'm using the wrong criteria (or just
having a brain fart). I have a formula that gets a value from a particular sheet: =Names!H35 What I want to do is substitute the sheet name for what's in a named range. i'e. I have a sheet named "XXX" I have a range named "LastSheet" The value of "LastSheet" is "XXX" How do I modify my original formula to use "LastSheet" to get whatever is in H35 on Sheet "XXX" ? Thanks, John |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Use a range value in place of sheet name
Use the INDIRECT function.
-- David Biddulph "John Wilson" wrote in message ... Tried searching for this but I guess I'm using the wrong criteria (or just having a brain fart). I have a formula that gets a value from a particular sheet: =Names!H35 What I want to do is substitute the sheet name for what's in a named range. i'e. I have a sheet named "XXX" I have a range named "LastSheet" The value of "LastSheet" is "XXX" How do I modify my original formula to use "LastSheet" to get whatever is in H35 on Sheet "XXX" ? Thanks, John |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Looking for formula to place score in a range of scores | Excel Worksheet Functions | |||
| How do I place Range text into a header? | Excel Worksheet Functions | |||
| how do I place the sheet tab name in my spreadsheet by formula? | Excel Worksheet Functions | |||
| How do I place multiple charts in the same sheet? | Charts and Charting in Excel | |||
| Is there a formula that will place the sheet name in a cell? | Excel Worksheet Functions | |||
Linear Mode
