I'm just trying to finish up this spreadsheet and have run into one last
problem (I hope). I have 2 spreadsheets set up right now...one has all the
customer information (name, contact, address, etc.), and the other has a drop
box linked to the customer info (using a defined range) list and has all the
fields lined up using the vlookup function. The only problem I am running
into now is that when there are multiple contacts with the same company, only
the top entry appears even though the correct number of company names
appears. Is there any way (preferably without using VBA) that I could get
this linked so all of the contacts would appear correctly?