Auto Data Fill Question?

[chetp]

Auto Data Fill Question? Newbie

I have a workbook to invoice customers. In the workbook I have multiple invoice sheets, a totals sheet, and a custname sheet. The custname sheet contains columb headings of Cust#, CustName,Address,and city_st_zip.

My question is: May I fill in or look up from a list in a cell (say c7) on the customer invoice sheets and fill (C7)with the customer number (Unique) found in another sheet called (Custname). After excel fills in this information I would like excel then to fill in the custname, address and city_St_zip.

Sheet 1 called Custname
A1- Cust#
B1- Custname
C1- Address
D1- City_St_zip

Sheet 2 called Invoive

Cell on Invoice sheet C7 would lookup from a list or be entered manually the cust# found on Sheet Custname.

Excel would then find data from the Custname sheet and copy it to cells on Invoice sheet.

G10 would contain the Custname based on the Cust# found inC7
G11 would contain the address
G12 would contain the city_St_zip all based on custnumber in C7

I have excel 2002 but need this to work with Excel 97.

I am really new at this and it has been driving me nuts Thanks in advance.

Thanks in advance
Chet

 

[PaddyD]

You're welcome.

 

[Todd Bardoni]

For future reference, you need to work through the formula. There are people (Aladin) that post formulas, that even to a seasoned XL user, make no sense. The only way to make sense of them is to get down and dirty and start picking apart the formula. Type it out character by character. Type it out a few times. Change things in the formula and see what kind of result you get. This is the only true way to learn. I'm descent at Excel and the Help files, most of the time, help me only minimally (although I still read through them).

Learn by doing and then doing again.

 

[DougStroud]

PaddyD,
Got it now. I did not get the concept that the lookup started with the value in the current worksheet. I was looking to the table initially. I would not have gotten how to look for two values had Aladin not shown me how to combine two values on the table.
With the reference link you provided, which explains the VLookup very clearly and Aladin's solving the 2nd part I have gotten the concept down better now.


Thanks you.

Doug