Excel drop down list that filters applicable results

[MissAudrey]

I have created a simplified example of what I would like to do.

1. There is a list of names and an associated car for each name. Some people may own multiple cars so in these cases there are there are multiple entries.
2. In another section of the spreadsheet, I need to enter a person's name. I would like to create a drop-down list (or some other filtering tool) that provides a list of options for the cars that person owns. I would like the ability to select one of the cars.

I know I could create a column for each name and list the cars under the applicable name and then name the range. In the Data Validation formula I could use an if statement to reference the correct list. **This is a simplified example of what I am trying to do. In my real life application, I am dealing with ~100 names. I don't think this approach will work.**

Here's the example. I have also attached a spreadsheet.

1. List
Arthur Golf
Jack Highlander
Jill Escape
Jack Sienna
Arthur Mini Cooper
Jack Outback

2. In another section of the spreadsheet I want to enter the names and have a filter provide the following:

Arthur: formula for dropdown list to select "Golf" and "Mini Cooper"
Jill: formula for dropdown list to select "Escape"
Jack: formula for dropdown list to select "Highlander" and "Outback"

[davesexcel]

Look at the example found here
http://www.contextures.com/xlDataVal13.html#Create
Down load the example and change the values in the ranges, and see how it works.

I have downloaded Debs wb and changed the data to show you what I am talking about.

[MissAudrey]

Dave, your example worked great!
I have one other question. Is there a way to always add a category of "other" in the drop down list? I was hoping I could do this in the data validation formula (offset(RegionStart, MATCH(B2,RegionColumn,0)-1,1,countif(RegionColumn,B2),1)

I want the results to be filtered but in my example above I want the following:
Arthur: formula for dropdown list to select "Golf", "Mini Cooper", "Other"
Jill: formula for dropdown list to select "Escape", "Other"
Jack: formula for dropdown list to select "Highlander", "Outback", "Other"

Thanks!