Remember Me?

#1
May 23rd 05, 10:10 AM
 Wendy Posts: n/a
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.

#2
May 23rd 05, 02:09 PM
 Bernard Liengme Posts: n/a

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" wrote in message
...
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.

#3
May 23rd 05, 02:17 PM
 Duke Carey Posts: n/a

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.

 Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On

 Similar Threads Thread Thread Starter Forum Replies Last Post trainer2000 Excel Discussion (Misc queries) 1 May 20th 05 08:42 PM Satnam Patel Excel Discussion (Misc queries) 4 May 5th 05 01:42 PM Pedro Excel Worksheet Functions 2 January 18th 05 04:38 AM Pedro Excel Worksheet Functions 1 November 9th 04 07:27 PM Pedro Excel Worksheet Functions 0 November 9th 04 07:26 PM

All times are GMT +1. The time now is 10:36 PM.