Data Validation List with an "IF" statement?

[Mccann]

Hey Guys!

I own a valet parking company

I have a list for the guys that says which day of the week they are available to work.
I have a list for the guys that says which accounts they have been trained at.
I would like to have a data validation drop down list that cross references the 2 lists and shows who is trained, and who is available.

With that said, I would also like to be able to reference a cell in the same row that has a date in it.

So essentially I need to figure out how to combine the (2) lists with one of the date variable dependent on a cell value

Thanks in Advance!

 

[Mccann]

For this stage of the workbook yes, but eventually I want to remove them from other lists if they are committed to another location on the same day.

 

[oldbrewer]

an if statement checking each location could flag "committed" if any location returned true....

 

[Mccann]

Awesome concept, that's a great approach!