Those sites were very helpful, except I found out that you can not do data
validation to a different worksheet. That leads to a couple more problems,
which I'm not sure how to fix.

1. We are going to be sorting by company name, then having the contact and
address, etc. come up once the company name is typed in. Unfortunately, we
have multiple contacts at some companies, so is there a way to do the vlookup
and have a choice of which contact name to use if the company name is the
same (I tried it the way I thought would be correct, and the results were
quite underwhelming).

2. Is there a way to have the Company name AutoFill as you are typing? For
example, if i typed "McD" then McDonalds would autofill (presuming we only
had one contact there)

Thank you in advance!