I am trying to use data validation to select contacts by company name (I have
800 of them), my problem is I have several contacts from the same company and
excel wont differentiate between them when I use the company name to sort.
eg. if I select company 'x' it will show contact 'a1', when I want contact
'a2'. I dont know how to do this, PLEASE HELP ME!!!! I am also using the
company information to vlookup the rest of the information that belongs with
the company.