| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I use cell contents as an address in a formula
I want to create a formula like follows:
= 'sheet name'!B38 where 'sheet name' is the contents of another cell, such as g2. So, if g2 contained "Division 1" as its contents, the formula would return the contents of the cell B38 on thesheet labeled "Division 1" |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I use cell contents as an address in a formula
=INDIRECT("'"&G2&"'!B38")
-- Regards, Dave "tomeck" wrote: I want to create a formula like follows: = 'sheet name'!B38 where 'sheet name' is the contents of another cell, such as g2. So, if g2 contained "Division 1" as its contents, the formula would return the contents of the cell B38 on thesheet labeled "Division 1" |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Using cell contents within a formula | Excel Worksheet Functions | |||
| Using contents of a cell in a formula | Excel Discussion (Misc queries) | |||
| Possible Lookup Table | Excel Worksheet Functions | |||
| Formula checking multiple worksheets | Excel Worksheet Functions | |||
| GET.CELL | Excel Worksheet Functions | |||
Linear Mode
