I need to create a list of names based on associated dates from another book.

For example, say a list of people need a car by a certain date, and I have a list of cars and the dates they are available, how can I generate a list of all the cars that will be available for each person?

It does not need to be presented as I have shown, thats just the idea.

It would be even better if following on the list could break down and say "car available 7 months in advance" , "car available 6 months in advance" etc.

customer

cars

Final output