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