That worked perfectly. What I am doing is pullong in survey results. For each
person there is 15 questions. Could I use a VLookup to pull the data then
format my main sheet to drive the reporting functions?

"Gord Dibben" wrote:

Scott

See Debra Dalgeish's site for "dependent DV dropdowns"

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


Gord Dibben MS Excel MVP

On Tue, 19 Dec 2006 09:45:01 -0800, Scott@CW
wrote:

I have a list of 96 names that fall into 7 departments. I have created a data
valaidation list for each grouping. But when I do a IF statement to reference
the DV cell it does not work. Any ideas? I want the user to first choose a
department, then from that choice choose from only the names that fall into
that department group.

Gord Dibben MS Excel MVP