But when I do a IF statement to reference
the DV cell it does not work.

An IF statement to do what?

Need more detail!

Biff

"Scott@CW" wrote in message
...
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.