Hi there -

I have drop down boxes containing names in D24:G24. All the drop down names are the same in each cell. Based on what name the user selects I would like to be able to check a range D1:G1 to see if the name exists in this range. If it does I would like a message box to appear "Resource on vacation please select another name".
Then have the drop down box clear the name out.

Can you any direct me.

Thank you!

Lorraine