Enter last name, auto fill full name & address--HOW?

G

Guest

Hello,

I'm trying to simplify a "customer info" form in which a commonly used
individual and his/her full name, address, phone #s, etc. is required. Is
there a method in which I can enter a keyword (preferably the individual's
last name) and Excel will automatically insert his/her full name, address,
etc.? There is a large list of individuals that require this shortcut.

For Example:
If I enter "Robertson", can Excel automatically enter (in place of
"Robertson"):

Mr. John Robertson
111 Any Street
Anytown, ON A1A 1A1
Phone: (555) 555-5555
Fax: (555) 555-5555
Email: (e-mail address removed)
 
D

Don Guillett

You can use vlookup functions or a worksheet_change event macro to do this.
I would use the macro.
 
G

Guest

Yes, set up a grid with all the information using horizontal column headers
like, last name, first name, address1, address2, phone, etc. and then you can
use the vlookup function on this list(pretty straightforward in help). One
note though, vlookup always will look up the first column of your grid, so
the last name should always be the first column.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top