Multiple data validation in one cell.

[mrin74]

I am booking staff holidays and looking for 3 restrictions:

On Holiday Entry Sheet:
Column A when I type "Badge" number and using vlookup it fills B:G except D.

Restriction 1:
If I type a same date for the same staff, I want a error messege "YOU HAVE ALREADY BOOKED THIS DATE".

Restriction 2:
If I type a date and staff is not contracted on that day, I want a error messege "YOU ARE NOT CONTRACTED ON THIS DAY".

Restriction 3:
All the dates I will type will be restricted between a range (i.e. 01/01/2020 to 31/12/2020). Any date I type outside this range would give me a error messege "DATE IS OUTSIDE THE HOLIDAY YEAR"

[Pepe Le Mokko]

Administrative note

Still using XL2003 as indicated in your profile?
If not,perhaps update your profile as necessary to properly reflect the exact version(s) of Excel your question relates to? Members tailor answers based on your Excel version.
Thanks

[Pepe Le Mokko]

Administrative Note:

Welcome to the forum

We would very much like to help you with your query, however it has been brought to our attention that the same query has been posted on one or more other forums and you have not provided the required cross-post link(s) here.
Read this to understand why we (and other sites like us) consider this to be important.

As you have less than 10 posts I will add it for you.Please read forum rules

https://www.mrexcel.com/board/thread...-cell.1128122/