ExcelBanter - Index formula help

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Index formula help (https://www.excelbanter.com/excel-discussion-misc-queries/60309-index-formula-help.html)

Luke

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

Niek Otten

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

All times are GMT +1. The time now is 06:43 AM.