Drop down menu

[Guest]

I’ve created a drop down list box from the Data Validation tab with the
following text, Austin, Houston, and Dallas. I created another drop down
list for an each cities stores (each has15 locations). I want choose one city
and only the corresponding locations will show, how do I accomplish this
task? Is there a formula I need to create?

Thank you in advance,

 

[Guest]

See the Dependent Lists section of Debra Dalgleish's excellent website for
instructions:

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

Does that help?
***********
Regards,
Ron

XL2002, WinXP

 

[T. Valko]

You need to create a table that lists all the stores for each location.

Assume your drop down is in A1 and has the selections for the locations:
Austin, Houston, Dallas

In some area of your sheet create a table like this:

...............F...............G................H
1........Austin.......Houston.......Dallas
2..........A1..............H1.............D1
3..........A2..............H2.............D2
4..........A3..............H3.............D3


Now, give each one of these columns a defined name:

Select the range F2:F4 then click in the name box (all the way on the left
side of the formula bar where it shows you what cell is selected) and type
in Austin then hit ENTER. Do the same for the other columns and name them
Houston and Dallas.

Now, set up your dependent drop down:

Assume you want this drop down in cell B1.
Select cell B1
Goto Data>Validation
Allow: List
Source: =INDIRECT(A1)
OK

If you currently have nothing selected from the drop down in A1 you will get
a message saying that the source current evaluates to an error and do you
wish to continue. Just select Yes.

Biff

 

[Gord Dibben]

Randall

See Debra Dalgleish's site for how-to.

http://www.contextures.on.ca/xlDataVal02.html

I’ve created a drop down list box from the Data Validation tab with the
following text, Austin, Houston, and Dallas. I created another drop down
list for an each cities stores (each has15 locations). I want choose one city
and only the corresponding locations will show, how do I accomplish this
task? Is there a formula I need to create?

Thank you in advance,

Gord Dibben MS Excel MVP

 

[Guest]

Randall

See Debra Dalgleish's site for how-to.

http://www.contextures.on.ca/xlDataVal02.html

Thank you for the great information, I found it very useful and easy to administer. I am on to the next level, VLookup and IF statements. Randall




Gord Dibben MS Excel MVP

 

[Gord Dibben]

See Debra's site also for great help on VLOOKUP.

http://www.contextures.on.ca/xlFunctions02.html


Gord


Gord Dibben MS Excel MVP