Find addresses based on codes

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
Hi Elia,
try VLOOKUP Worksheet Formula, see
http://www.mvps.org/dmcritchie/excel/vlookup.htm



Elia said:
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
Click to expand...
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?
 
Back
Top