need to display lists

[jwtcp]

I have a worksheet that mas multiple company names, and under each company there are employee names, some company's might only have one employee name others mite have several employees. Im looking for a lookup functions that when typing in a spacific company name a list of its employees will be displayed. I greatly appreciate ay help I can get.

Thank you very much
Shawn

 

[DauntingGecko]

There's different ways to do it, but neither of them have a really easy route. Do you want the employees to appear in a drop down so you can select one? Or as a complete list in your spreadsheet?

Try looking at existing solutions: http://www.ozgrid.com/forum/showthread.php?t=25239&page=1

 

[jwtcp]

I appreciate your help. I am putting together a spread sheet that when you put a company name in a cell (a1) in another cell will display a list of all the employees that are with that company (B1). This is mainly used for sales.

Once again I really appreciate all your help.
Shawn