I have two separate spreadsheets that I need to merge. The common link is a list of names. The one spreadsheet has 1924 rows of names and information; the other spreadsheet has 931 rows of names and information. I want to merge information from the spreadsheet with 1924 rows into the matching name on the spreadsheet with 931 names.
In the workbook with 931 names (say, Workbook A), use VLOOKUP formulas to bring across the data from the other workbook (say, Workbook B). Assuming the names are in column A in both workbooks, the formula would look something like this:
=VLOOKUP($A1,'[Workbook B.xls]Sheet1'!$A$1:$J$2,2,FALSE)
This formula will return the second column in the above data range in Workbook B - in this case column B. When you fill the formuls across the columns where you want each column from Workbook B to be inserted, change the column reference 2 to the next number - i.e., 3 will return column C, 4 will return column D, etc. Change the data range in the formula to suit your own spreadsheet.
Search for VLOOKUP in Excel's help system and you will find lots of examples and an explanation of how VLOOKUP works. There are also lots of threads in this forum, so a search here will also give you lots of ideas.
Trish in Oz
-------------
A problem well defined is a puzzle half solved
If you attach a sample of your workbook it will be easier to find a solution.Remember to remove/replace sensitive data before uploading the file. Look here if you need help with attachments:
http://www.excelforum.com/faq.php?fa...b3_attachments
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks