i need a formula so when if in a drop down menu that selection has already
been taken from another drop down menu i can place a message to say that the
selection was already used/taken.

thanks
chris