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.

"ana maria" wrote:

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: