Help needed in setting up list of clients

**joel_e** · 05-28-2009, 08:05 AM

Hi all

I am using the Mac 2004 version of excel, and I have a basic understanding of excel. Every week I need to produce a list of clients that appear in a publication, along with details that never change (e.g. their respective telephone numbers, email addresses, etc). Its a very monotonous task to do this manually, and i'm sure there must be a way to help automate the process in excel.

Ideally, I would like to be able to simply enter the clients name in one field so that their contact information then automatically appears in adjacent cells. I have played about with macros, lists, pivot tables, but i'm not quite sure what i'm doing. Can anyone help me out?

Thanks

**NBVC** · 05-28-2009, 08:18 AM

Have you looked at the Vlookup() function?

You can enter a name and get the details from a separate database where all the names and relevant info appear.

e.g. =Vlookup(A1,Database,2,0)

would get info from column 2 of the Database (which is a table range) where A1 would be matched to items in column 1 of the Database