dyowell

First, on Sheet2 you would have a table with 5 columns containing your list of
customers under these headings....

Code, Name, Address, City, State

Select that table and InsertNameDefine. Call it mylist.

Now, assuming you enter the code number in A1 of Sheet1 and you want name in
B1, address in C1, city in D1, state in E1.

In B1 enter =VLOOKUP($A$1,mylist,2,FALSE)
In C1 enter =VLOOKUP($A$1,mylist,3,FALSE)

For D1 and E1 just advance the number to 4 and 5

In all cases, your cell references may differ. Adjust to suit.

Gord Dibben Excel MVP



On Tue, 20 Jul 2004 11:06:58 -0700, "dyowell" wrote:

I have two small spreadsheets. One is a spreadsheet that
I use to produc quotes. The other is a spreadsheet that
has a list of customers. I would like to enter the
customers account number on the quote and have all of the
rest of the information (name, address, city, state, etc.)
entered automatically. I have looked at the vlookup
function but I don't seem to be doing it right. Could
someone please let me know if this the the right function
to use and how to use it correctly. Thanks.