chris-evans
Board Regular
- Joined
- Feb 19, 2002
- Messages
- 73
Hi all.
I have a drop down box of range names from which I want the user to select a particular name.
The chosen name gets put in a cell (say A1).
I then have an index formula that looks to A1 eg:
=index(A1,,2)
The only problem is that the formula fails as Excel does not recognise the contents of A1 as a range name. It stores it as a text string.
Is there any easy way I can get around this and make Excel notice this text string as a range name? I know how to do this using VBA but I would rather do it in a formula if possible.
Any help would be greatly appreciated!!
Thanks
Chris
I have a drop down box of range names from which I want the user to select a particular name.
The chosen name gets put in a cell (say A1).
I then have an index formula that looks to A1 eg:
=index(A1,,2)
The only problem is that the formula fails as Excel does not recognise the contents of A1 as a range name. It stores it as a text string.
Is there any easy way I can get around this and make Excel notice this text string as a range name? I know how to do this using VBA but I would rather do it in a formula if possible.
Any help would be greatly appreciated!!
Thanks
Chris