drop down list based on a lookup

[erenkey]

I have a sheet that lists out all of our customers. I want to create a dropdown list on a separate sheet that only contains the contacts associated with the company name that is indicated. Is this possible?

 

[levy77]

How do you have the contacts associated with the companies? Do you have a list of customers with their company next to them?

 

[kweaver]

I created a test file with a bunch of fake names of people and companies.

Try this: https://www.dropbox.com/h?preview=erenkey.xlsx