Can I create a drop-down list that will reference other drop-down
 

--
Thanks for your help in advance.

Can I create a drop-down list that will reference other drop-down
 

You can create dependent data validation lists. There are instructions
he

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


fdebelo wrote:

--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

Can I create a drop-down list that will reference other drop-down
 

I have a drop down list in A3 with 2 items in the list. If i select the item
1 from A3 list, I would like to open the drop down list in A4, and see the
list associated with item 1 in A3.

If I select item 2 in A3, the list in A4 would be a different list, one that
is associated with A3. is this possible without utilizing access?
--
Thanks for your help in advance.


"fdebelo" wrote:


--
Thanks for your help in advance.

Can I create a drop-down list that will reference other drop-down
 

In a simple example as you give, all you need is something like this formula
in your second DV, type of list

=if(F1=1,m1:M4,N1:N4)

better still use named ranges.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"fdebelo" wrote in message
...
I have a drop down list in A3 with 2 items in the list. If i select the
item
1 from A3 list, I would like to open the drop down list in A4, and see the
list associated with item 1 in A3.

If I select item 2 in A3, the list in A4 would be a different list, one
that
is associated with A3. is this possible without utilizing access?
--
Thanks for your help in advance.


"fdebelo" wrote:


--
Thanks for your help in advance.