Find addresses based on codes

[Elia]

Hi
I am trying to create a data file to produce statements for my customers by exporting the data from excel into word. My problem is with excel. I have two worksheets. Data worksheet starts with a customer code in cell A2 and the invoice data in the same row. Addresses worksheet contains all my customers and their codes beginning in cell A2 as well. How can I create a formula that will look for the code in the Addresses worksheet and copy the cells to the right
I am new at this, so thanks a lot.

 

[David McRitchie]

Hi Elia,
try VLOOKUP Worksheet Formula, see
http://www.mvps.org/dmcritchie/excel/vlookup.htm

---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

Hi,
I am trying to create a data file to produce statements for my customers by exporting the data from excel into word. My problem is

with excel. I have two worksheets. Data worksheet starts with a customer code in cell A2 and the invoice data in the same row.
Addresses worksheet contains all my customers and their codes beginning in cell A2 as well. How can I create a formula that will
look for the code in the Addresses worksheet and copy the cells to the right?