I believe what you're looking for might be "Dependant" lists.

That way, you choose a company from one list, and then have another drop
down display the contents (contacts) of that particular company list.

Check out Debra Dalgleish's extensive web site on this subject:

http://www.contextures.com/tiptech.html

Scroll down to "D", and check out all the pages on "DataValidation",
especially the one on "Dependant Lists".
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================



"Matrix015" wrote in message
...
Ok then, I am trying to auto fill fields using data valadation drop down
list
and a vlookup to fill in the fields, the problem that i am having is that
when I select a company name from the valadation drop down field it will
only
give me the first contact related to the company. I am trying to get it to
relate each instance of the company name in my contact list to the row
number
that it is actually in, instead of just finding the first instance of the
company name and returning that info. Hope that better explains the
problem,
and I hope you can help!!!!