Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old May 23rd 05, 10:10 AM
Wendy
 
Posts: n/a
Default 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   Report Post  
Old May 23rd 05, 02:09 PM
Bernard Liengme
 
Posts: n/a
Default

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   Report Post  
Old May 23rd 05, 02:17 PM
Duke Carey
 
Posts: n/a
Default

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.



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel Range Names trainer2000 Excel Discussion (Misc queries) 1 May 20th 05 08:42 PM
Deleting Range name's listed in the range address box. Satnam Patel Excel Discussion (Misc queries) 4 May 5th 05 01:42 PM
range names Pedro Excel Worksheet Functions 2 January 18th 05 03:38 AM
range names Pedro Excel Worksheet Functions 1 November 9th 04 06:27 PM
range names Pedro Excel Worksheet Functions 0 November 9th 04 06:26 PM


All times are GMT +1. The time now is 12:19 AM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017