The situation that I'm trying to solve with your help is as follows:
Suppose you have 3 cars.
In the colon, we have A2 = car 1, A3 = car2, A4 = car3
In column B - we have a situation where the three cars are in the garage, that in cells B2, B3, B4 can put the letter Y for "yes" - that car is in the garage.
What I want is the allocation of cars for work1, work2, work 3 with the following:
In cell D2 work1 example I can choose the type drop-down list only cars are in the garage, are available.
If one car is in service - in cell C2 put the letter y in "yes" - (that car is in service / repair) - that machine does not appear in the drop-down list in cell D2.
For cell E2 work2, I could choose cars that are not in service and who have not been selected for work1
or work2
See
car.xlsx

thxxxxxxxxx in advance