Using Range Names in Formulae

[chris-evans]

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

[Aladin Akyurek]

On 2002-02-25 06:52, chris-evans wrote:
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

Try:

INDIRECT(A1) as part in your formulas.

[chris-evans]

Worked a treat! - Thanks!