formula for text

[Betty S]

I am using Excel for course scheduling. I have a drop-down menu in one
column with departments. If the user selects a given department, I would
like the next column then to have a drop down menu showing them the names of
courses available in their department only (rather than one huge list of all
the course names from all departments). I do not know whether Excel has a
formula that might work for this instance? If anyone has ideas, I would be
most grateful. Thank you!

 

[Bob Phillips]

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

 

[Betty S]

Bob -- absolutely wonderful. Just what I needed. Thanks a million.
-betty