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)



"Stuck with Excel" <Stuck with wrote in
message ...
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?