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


"Randall" wrote:

Ive 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,