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.