software

I would like to create a database of clients in Microsoft Office 2003 in
order to merge with an invoice without typing the customer information
everytime I need an invoice. I would like to be able to enter the client ID
#, which would import all the client mailing information I need for the
invoice.

Brenda

You can use a series of VLOOKUP formulas and a Lookup table to return customer
info to various cells based on the entry of an ID number.

Check out Help on creating a Lookup table and using the VLOOKUP Function.

Also visit Debra Dalgleish's site for more on Data Validation drop-down lists
and VLOOKUP formulas.

www.contextures.on.ca/xlDataVal01.html

www.contextures.on.ca/xlFunctions02.htmlGord Dibben MS Excel MVP

On Tue, 25 Apr 2006 09:04:02 -0700, Brenda L. Carroll lt;Brenda L.
gt; wrote:

gt;I would like to create a database of clients in Microsoft Office 2003 in
gt;order to merge with an invoice without typing the customer information
gt;everytime I need an invoice. I would like to be able to enter the client ID
gt;#, which would import all the client mailing information I need for the
gt;invoice.

Gord Dibben MS Excel MVP