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?

I am not understanding where the Contacts are not showing up. If you want,
send me a sample worksheet and details and I will give it a go.


Rgards,
Howard

"Few more questions" wrote in
message ...
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?