Data validation

[Baker]

In a cell I want to put a drop-down list for Data
Validation. The source of the list needs to be controlled
based on another parameter.

For example, let's say that I have departments in one
column and department-members in another column. Now, in
a separate part of the spreadsheet, if the user enters
department name in cell B2 (for example) and when he goes
to cell C2 he should be given the drop down list with only
the members that belong to the department typed in cell B2.

Lots of thanks for all help that you folks would provide.

 

[J.E. McGimpsey]

Debra Dalgleish has an excellent tutorial on dependent data
validation lists:

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

 

[Baker]

Wow, awesome.

Thank you all.

-----Original Message-----
provide.

Fully described here under "dependent lists":
http://www.contextures.on.ca/xlDataVal02.html


.

 

[Jim]

I have not looked at this entire thread, but I have an idea of the problem,
or at least a common mistake.

Set up your list of fruits (or whatever) and in A2 and name it "FRUIT" (no
quotes). Use Data>Validation>Allow>List>=FRUIT. Among the fruits listed is
Apple.

Now you have to create a list of apples: MacIntosh, Granny Smith, Fuji, etc.
Name the list of apples...ta-da!..."apple". No quotes, naturally.

In B2 use Data>Validation>Custom>=INDIRECT(A2).

In both cases, be sure to check the In-Cell Dropdown option

Greeting from the Gulf Coast!
http://myweb.cableone.net/twodays