Formulae using range names

I've used a formula (= Possible Major) which uses range names to return the
intersect of two named ranges, where Possible is one named range and Major is
another.

This works fine if I type the formula in directly but I want to return the
value from the cell references instead i.e. I have two drop downs for data
validation so the user can select Possible in column C and Major in column D.
I am therefore trying to use =C11 D11 which I hoped would be 'translated' to
=Possible Major and therefore give me the correct answer as if typed in
manually.

Does anyone know if it is possible to do this.
Thanks.

Hi Wendy,
This worked for me with text typed into C1 and D11
=INDIRECT(C11) INDIRECT(D11)
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email


"Wendy" <Wendy@discussions.microsoft.com> wrote in message
news:347A6DD7-E913-495F-8C6F-9EAD17941AA1@microsoft.com...
> I've used a formula (= Possible Major) which uses range names to return
> the
> intersect of two named ranges, where Possible is one named range and Major
> is
> another.
>
> This works fine if I type the formula in directly but I want to return the
> value from the cell references instead i.e. I have two drop downs for data
> validation so the user can select Possible in column C and Major in column
> D.
> I am therefore trying to use =C11 D11 which I hoped would be 'translated'
> to
> =Possible Major and therefore give me the correct answer as if typed in
> manually.
>
> Does anyone know if it is possible to do this.
> Thanks.

Wendy - try this formula

=INDIRECT(c11) INDIRECT(d11)

"Wendy" wrote:

> I've used a formula (= Possible Major) which uses range names to return the
> intersect of two named ranges, where Possible is one named range and Major is
> another.
>
> This works fine if I type the formula in directly but I want to return the
> value from the cell references instead i.e. I have two drop downs for data
> validation so the user can select Possible in column C and Major in column D.
> I am therefore trying to use =C11 D11 which I hoped would be 'translated' to
> =Possible Major and therefore give me the correct answer as if typed in
> manually.
>
> Does anyone know if it is possible to do this.
> Thanks.