Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Index formula help
I am trying to link the named range section of my index formula to a drop
down list. e.g. instead of INDEX(W5e01,3,1) I am trying to link to a cell containing 'w5e01' such as INDEX(A1,3,1). The reason for this being so I can change the named range. However it does not appear to be working. Any ideas? Thanks |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Index formula help
Use the INDIRECT() function
Look in HELP for details -- Kind regards, Niek Otten "Luke" wrote in message ... I am trying to link the named range section of my index formula to a drop down list. e.g. instead of INDEX(W5e01,3,1) I am trying to link to a cell containing 'w5e01' such as INDEX(A1,3,1). The reason for this being so I can change the named range. However it does not appear to be working. Any ideas? Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to write the formula using INDEX? | Excel Discussion (Misc queries) | |||
index match formula | Excel Worksheet Functions | |||
Sum and Index formula? | Excel Discussion (Misc queries) | |||
Match / Vlookup within an Array formula | Excel Discussion (Misc queries) | |||
Min formula not returning value from Index | Excel Worksheet Functions |