Vlookup would require that the data is arrange with the account number as
the leftmost column in your table.

assume

acctno name address city state
A2 B2 C2 D2 E2
A3 B3 C3 D3 E3
A4 B4 C4 D4 E4


assume the above is on sheet1. Assume A2 represents both the location A2
and the account Number is A2, the name is B2 in cell b2, etc just for
simplicity.

on sheet2,

A1: A3 (A1 holds the acct number A3)
B1: =Vlookup($A1,Sheet1!$A$2:$E$4,2,False)
C1: =Vlookup($A1,Sheet1!$A$2:$E$4,3,False)


--
Regards,
Tom Ogilvy

"dyowell" wrote in message
...
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.