I have two adjacent data validation lists. The first provides vice
president names and the second sales director names. When the user
selects from the first (a vice president), I would like the second to
automatically select the correct matching sales director. However, I
also want to give the user the option to override the normal matching
name, in which case the program should not change his/her selection.

Thanks.