I have a similiar setup right now, but in order for it to work, you need
to device a form of grouping. The way I have to set it up was Clients
Names, Last, First. Then all the companys they are associated with.
That would enable you to select the name in a drop down list, in
another cell of your choice a drop down list would come up with all the
companys names for that person. Another more complicated way I cant
explain, it envolves offset, match, and lookup formulas. But it would
enable you to type all or part of the name and the companys will show
in a set amount of cells. Again, grouping is key. Let me know what
intrest you the most and I may be able to get you going.


--
comotoman
------------------------------------------------------------------------
comotoman's Profile: http://www.excelforum.com/member.php...o&userid=27292
View this thread: http://www.excelforum.com/showthread...hreadid=503364