| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Can you have 2 indirects refernces in one formula??
For example...
=INDIRECT("'"&$C$3&"'!d4") How can I have the user define the column (by replacing D) $c$3 references the dropdown value (user preferred worksheet) Thanks all!!!! |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Can you have 2 indirects refernces in one formula??
Simply extend it, like so:
=INDIRECT("'"&$C$3&"'!"&$D$3&"4") where D3 would contain the "D" -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "DMD1236" wrote: For example... =INDIRECT("'"&$C$3&"'!d4") How can I have the user define the column (by replacing D) $c$3 references the dropdown value (user preferred worksheet) Thanks all!!!! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| do cell refernces have to move when I cut and paste? | Excel Discussion (Misc queries) | |||
Hybrid Mode
