Copying Data from 1 xls into another xls but the data needs to match the names

[markus8]

Is there a way to copy data from 1 excel sheet to another that corresponds to a certain cell by matching names?

my situation:
A.xls contains customer name and invoiced totals for the year. (customers active for the year so an entry of ~1000)
B.xls contains customer name and addresses. (all customers ~3000+)

I want to add the customers invoiced totals from A.xls to list B.xls matching it by customer name (so that i can have their address).
Is this possible?

[FDibbins]

if you have matching data in each file and want to add additional data from 1 file to another, you cam use vlookup for that. i cant tell you what the syntax would be unless i see what you're files look like.

To Attach a File:

1. Click on Go Advanced
2. In the frame Attach Files you will see the button Manage Attachments
3. Click the button.
4. A new window will open titled Manage Attachments - Excel Forum.
5. Click the Browse... button to locate your file for uploading.
6. This will open a new window File Upload.
7. Once you have located the file to upload click the Open button. This window will close.
8. You are now back in the Manage Attachments - Excel Forum window.
9. Click the Upload button and wait until the file has uploaded.
10. Close the window and then click Submit.