drop-down menus and nested references
 

I am trying to make a series of drop-down menus wherein the list used for the
second drop-down changes based on what is selected in the first drop-down.
Because there are more than seven options in the first menu, I can't just do
an =IF() function. Is there any way to force the calculation of a reference
within another formula? For example, if I have named lists A, B, and C and
the first drop-down menu in A1 contains the options A, B, and C, how do I get
the drop-down menu in A2 to read A1 as a list name instead of a text item?

If there is no way to do this, does anyone have alternate ideas (other than
the obvious making one giant list that is sorted but not actually separated)?

-Lisa Fox

See http://www.xldynamic.com/source/xld.Dropdowns.html

--

HTH

RP
(remove nothere from the email address if mailing direct)


"LisAmardhis" wrote in message
...
I am trying to make a series of drop-down menus wherein the list used for
the
second drop-down changes based on what is selected in the first drop-down.
Because there are more than seven options in the first menu, I can't just
do
an =IF() function. Is there any way to force the calculation of a
reference
within another formula? For example, if I have named lists A, B, and C
and
the first drop-down menu in A1 contains the options A, B, and C, how do I
get
the drop-down menu in A2 to read A1 as a list name instead of a text item?

If there is no way to do this, does anyone have alternate ideas (other
than
the obvious making one giant list that is sorted but not actually
separated)?

-Lisa Fox

Check out Debra Dalgleish's web site where she has all the info you'll need
to accomplish this:

http://www.contextures.com/xlDataVal02.html
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


"LisAmardhis" wrote in message
...
I am trying to make a series of drop-down menus wherein the list used for
the
second drop-down changes based on what is selected in the first drop-down.
Because there are more than seven options in the first menu, I can't just do
an =IF() function. Is there any way to force the calculation of a reference
within another formula? For example, if I have named lists A, B, and C and
the first drop-down menu in A1 contains the options A, B, and C, how do I
get
the drop-down menu in A2 to read A1 as a list name instead of a text item?

If there is no way to do this, does anyone have alternate ideas (other than
the obvious making one giant list that is sorted but not actually
separated)?

-Lisa Fox

Thanks both of you for your prompt replies! Very helpful. :-)

-Lisa


"RagDyeR" wrote:

Check out Debra Dalgleish's web site where she has all the info you'll need
to accomplish this:

http://www.contextures.com/xlDataVal02.html
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


"LisAmardhis" wrote in message
...
I am trying to make a series of drop-down menus wherein the list used for
the
second drop-down changes based on what is selected in the first drop-down.
Because there are more than seven options in the first menu, I can't just do
an =IF() function. Is there any way to force the calculation of a reference
within another formula? For example, if I have named lists A, B, and C and
the first drop-down menu in A1 contains the options A, B, and C, how do I
get
the drop-down menu in A2 to read A1 as a list name instead of a text item?

If there is no way to do this, does anyone have alternate ideas (other than
the obvious making one giant list that is sorted but not actually
separated)?

-Lisa Fox