Finishing my Address Lookup

[Guest]

Ok, I wanted to do a dropdown menu to select the company from, but I also
wanted all of the data to be held on a separate worksheet. Since it does not
allow data validation to other worksheets, I have run into a few more
problems, in making the database usable.

1. I am using the VLOOKUP function to search company name and pull in the
company info (contact, address, etc.). The problem I have run into is that
some of the companies have multiple contacts (only the first entry appears
when doing the lookup). Is there a way to differentiate the entries for the
different contact names while still leaving the company name the same?

2. Is there a way to autofill the name of the company that I am typing?
For example if i were to type "McD..." then McDonald's (or a list of M's)
would appear in the cell without having to type the rest of the word in.

Thank you in advance!

 

[Guest]

Re Data validation: lists on Sheet1 can be used for Data Validation on Sheet2
providing they have been defined as named range(s).

Re VLOOKUP: if you need to extract multiple entries, you will a unique "key"
for each entry. You could then use INDEX/MATCH to extract the data OR VLOOKUP
with a combined key of Company name & contact (or similar).

Re autofill: if you are entering the names in multiple cells, then perhaps
use right click and "Pick from drop-down list".

If it is entry into a single cell, the a combo box for the Control Toolbox
would provide what you want.

HTH