Hi

I want to data validate two lists where the value choices are the same. Each list takes its data validation choices from a defined range. However, when a user selects a value from the first list, the corresponding value on the 2nd list will not have the value the user just selected.

Thus, when user selects A on List A, the dropdown box for List should only contain the choices which he did not select.

List A List B
-----------
A B
B C
C D
D

Can anyone help? Thanks