Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
merging two worksheets
I have two woksheets of voter data. The first worksheet has three columns:
Voter ID#, Election Date, Election discription, Voting Method. The second worksheet has multiple columns, the first being Voter ID#. The remaining columns are -First Name, Last Name, Street number, Street Name, Phone number, Precinct Name, ....and so on. I wish to pull the individual information columns from the second worksheet into the First worksheet based upon the 1st column that is common to both worksheets-Voter ID#. There are more entiries in the second worksheet than the first. I only need the additional info from the second worksheet for the Voter ID#s that are listed in the First worksheet. This is 140,755 rows for The First woksheet. I am a novice at this. I have the original data of these worksheets on a CD in text, comma deliniated format also, if this helps make it easier. I do not have Access, but I am not opposed to getting it if it would make this easier. -- Jim B |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
merging two worksheets
try Index/Match:
http://www.contextures.com/xlFunctions03.html Or, Vlookup: http://www.contextures.com/xlFunctions02.html HTH, Ryan--- -- Ryan--- If this information was helpful, please indicate this by clicking ''Yes''. "Jim B" wrote: I have two woksheets of voter data. The first worksheet has three columns: Voter ID#, Election Date, Election discription, Voting Method. The second worksheet has multiple columns, the first being Voter ID#. The remaining columns are -First Name, Last Name, Street number, Street Name, Phone number, Precinct Name, ....and so on. I wish to pull the individual information columns from the second worksheet into the First worksheet based upon the 1st column that is common to both worksheets-Voter ID#. There are more entiries in the second worksheet than the first. I only need the additional info from the second worksheet for the Voter ID#s that are listed in the First worksheet. This is 140,755 rows for The First woksheet. I am a novice at this. I have the original data of these worksheets on a CD in text, comma deliniated format also, if this helps make it easier. I do not have Access, but I am not opposed to getting it if it would make this easier. -- Jim B |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
merging two worksheets
Hi,
In the first worksheet, use the VLOOKUP() function. You may read up on the same in the Help menu - it is well explained. -- Regards, Ashish Mathur Microsoft Excel MVP www.ashishmathur.com "Jim B" wrote in message ... I have two woksheets of voter data. The first worksheet has three columns: Voter ID#, Election Date, Election discription, Voting Method. The second worksheet has multiple columns, the first being Voter ID#. The remaining columns are -First Name, Last Name, Street number, Street Name, Phone number, Precinct Name, ....and so on. I wish to pull the individual information columns from the second worksheet into the First worksheet based upon the 1st column that is common to both worksheets-Voter ID#. There are more entiries in the second worksheet than the first. I only need the additional info from the second worksheet for the Voter ID#s that are listed in the First worksheet. This is 140,755 rows for The First woksheet. I am a novice at this. I have the original data of these worksheets on a CD in text, comma deliniated format also, if this helps make it easier. I do not have Access, but I am not opposed to getting it if it would make this easier. -- Jim B |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
merging two worksheets
Looks like you have 4 columns of data in Sheet1, not 3.
If you have Excel 2007 then you will be able to get 140k rows of data on one worksheet, but if you are using XL2003 or earlier then you are limited to 64k rows per sheet. Try this formula in E2 of Sheet1 (assuming you have a header row): =IF(ISNA(MATCH($A2,Sheet2!$A:$A,0)),"",VLOOKUP($A2 ,Sheet2!$A:$G,COLUMN (B2),0)) I have assumed that you have data in coumns A to G of the second sheet, so you need to change the reference to suit your data. You can copy this formula across to suit the number of columns of data you want to bring from Sheet2, and then copy the formulae down for as far as you need to (though you may have to copy the formula down each column in turn, one column at a time - a quick way is to double-click the fill handle of the cursor (the small black square in the bottom right-corner of the cursor) with E2 selected, then F2 selected, and so on). Once you have done this you can fix the values from these formulae by highlighting all the columns containing formulae, clicking <copy, then right-click the mouse button and Paste Special | Values (check) | OK then press <Esc. Sheet2 can then be removed, and the updated Sheet1 saved with a new name (so as to preserve the original file). Hope this helps. Pete On Oct 15, 11:44*pm, Jim B wrote: I have two woksheets of voter data. The first worksheet has three columns: Voter ID#, Election Date, Election discription, Voting Method. The second worksheet has multiple columns, the first being Voter ID#. The remaining columns are -First Name, Last Name, Street number, Street Name, Phone number, Precinct Name, ....and so on. I wish to pull the individual information columns from the second worksheet into the First worksheet based upon the 1st column that is common to both worksheets-Voter ID#. There are more entiries in the second worksheet than the first. I only need the additional info from the second worksheet for the Voter ID#s that are listed in the First worksheet. This is 140,755 rows for The First woksheet. I am a novice at this. I have the original data of these worksheets on a CD in text, comma deliniated format also, if this helps make it easier. I do not have Access, but I am not opposed to getting it if it would make this easier. -- Jim B |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
merging worksheets | New Users to Excel | |||
merging worksheets | Excel Discussion (Misc queries) | |||
Merging worksheets together | Excel Discussion (Misc queries) | |||
merging worksheets | Excel Discussion (Misc queries) | |||
Need help merging worksheets | Excel Discussion (Misc queries) |