Results 1 to 2 of 2
  1. #1
    4 Star Lounger
    Join Date
    Mar 2005
    Location
    Leicestershire, United Kingdom
    Posts
    506
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Merge Two Workbooks (2000)

    Hi,

    We have two excel spreadsheets. The common constant in the two is the name of the person which is identical for each record.

    One spreadsheet has their address info etc. The other has contact information for them, how do I merge it into once spreadsheet?

    Any ideas would be helpful.

    Luke
    Best Regards,

    Luke

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 28 Times in 28 Posts

    Re: Merge Two Workbooks (2000)

    If you have Access, you can import or link both spreadsheets in a database, create a query that joins them on the name field, and export the query to Excel.
    If you want to do it entirely in Excel, you can use VLOOKUP formulas in one of the spreadsheets to look up info in the other one. If the names are in column A. such formulas would look like this:

    =VLOOKUP(A2,'[OtherWorkbook.xls]Sheet1'!$A$2:$E$101,4,FALSE)

    This formula looks up the name from cell A2 in the range A2:E101 in another workbook and returns the value from the 4th column.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •