Making a drop down list conditional

[concretetsunami]

i was trying to create two drop down menu in excel spread sheet. but data in second spread sheet depends on selection made in first drop down menu.
for instance:- first drop down menu can contain folloing data
"abc"
"xyz"
if user make the selection as "abc" in first drop down list then second drop down can contain its data as "1","2","3" where as if user make its selection as "xyz" then second drop down can contain its data as "100","200","300".

Is this possible with basic excel formulas?

[Portuga]

Check this link:

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

[concretetsunami]

I see how you can make a list. my question now is, can you put the info on another page and the drop-down list look up info on another page.

ex: page 1
_____ A______B_______C_____D
1--- DROP1---DROP2
*
2
*
3

PAGE2
_________A___________B____________C________D

1-----DROP1_LIST-----ABC_LIST-------XYZ_LIST
*
2----------ABC------------100------------ APPLE
*
3----------XYZ ------------200-----------ORANGE



so if on page 1 you pick "ABC" in "DROP1" it will only give you the options to pick in "DROP2" the list that is found on page 2 in B2:B3.

[concretetsunami]

Nevermind I think I found a way.

[blarson04]

I am actually working on similar and am stuck. I'm playing with lists and lookup, but can't get it to work exactly as hoped (which is close to the above problem).

Also - I need to be able to make multiple "smart" or "dynamic" lists (as I like to call them)... such that I could select something in A1 which would give me a particular DROP2 related directly to the choice in DROP1. Depending on the DROP2 selection, there may or may not be the ability to select a DROP3, etc...

_____ A______B_______C_____D
1--- DROP1---DROP2---DROP3---DROP4(maybe)
*
2
*
3

PAGE2
_________A___________B____________C________D

1-----DROP1_LIST-----ABC_LIST-------XYZ_LIST...etc
*
2----------ABC------------100------------ APPLE...etc
*
3----------XYZ ------------200-----------ORANGE...etc

Any ideas?