Address Dropdown Menu

[Stuck with Excel]

I'm trying to create a dropdown menu where the user could select a client
name/identifier from a drop down box, and the client Name, address, phone,
etc. would show up in the box on separate lines. Is there any way to do this?

 

[Bob Phillips]

You need data validation, http://www.contextures.com/xlDataVal01.html, and
VLOOKUP, http://www.contextures.com/xlFunctions02.html

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[Few more questions]

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!

 

[Bob Phillips]

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.

Yes you can, but you have to be a little circuitous.

The range on the sheet being referred to should be given a defined name
(Insert>Name>Define...) and use that name in DV

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).

That is tricky. You would need VBA to determine that there are many and
present a list to the user to select from, or maybe list them in the
worknook and get the user to put a checkmark alongside it. Doable, but not
VERY simple.

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)

Not with Data Validation, for that you need a combobox.