Autofill an Address block 1

[chuck1954]

I have a data base in my excel workbook. I have an area in my worksheet with Name:
Address:
City: State: Zip:
My data base has this information. How can I make a list for the name cell so that it will fill in all the address, city, state, zip cells at the same time.

Chuck

 

[DeLaMartre]

Hello Chuck,

Have you tried using the vlookup function? If not, I have created an example using your specs (assuming I understand what you are after) and can email it to you if you want.

If you are unfamiliar with this function, it is extremely useful over a broad spectrum of applications.

Please let me know. -Bob in California

 

[chuck1954]

Please fell free to email me the sample.

chuck1954@earthlink.net

 

[DeLaMartre]

Good Evening Chuck,

I emailed the example I created to the address you posted. The first table serves as the database from which the address field in the second table can pull information.

Please let me know if this has been helpful.

Thanks, -Bob in California

 

[chuck1954]

That worked great. I does have endless possibilities.

Thanks
Chuck

 

[DeLaMartre]

Glad to have helped, Chuck. Welcome to Tek-Tips! -Bob in California