| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Reference Sheetname in Formula
at present this formula is sucessful: in cell G7 I have: =INDEX('[012007 Cash.xls]Day4'!$T$150:$T$354,$C7+1-150,1) In Cell G4 I have text Day4 How can I alter my formula to read the G4 value in place of the hard-coded Value? something like ,,,, =INDEX('[012007 Cash.xls] Indirect($G$4) '!$T$150:$T$354,$C7+1-150,1) ?? Any help appreciated.. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sheetname formula | Excel Worksheet Functions | |||
| Using a cell to reference sheetname in vlookup function | Excel Worksheet Functions | |||
| Formula that returns the sheetname | Excel Discussion (Misc queries) | |||
| How do I have a formula lookup a sheetname? | Excel Worksheet Functions | |||
| Replace a sheetname with a cell reference to link to another work. | Excel Worksheet Functions | |||
Threaded Mode
