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

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


Gord

On Mon, 27 Nov 2006 12:40:02 -0800, Randall
wrote:



"Gord Dibben" wrote:

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


On Mon, 27 Nov 2006 09:27:01 -0800, Randall
wrote:

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


Gord Dibben MS Excel MVP