VLOOKUP will pull the data.

Formatting and driving are up to you and the layout.

See Debra's site for help on VLOOKUP on the value you choose in the DV dropdown.

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


Gord

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

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