Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Match & combine rows from 2 worksheets
I have two worksheets w/ data that I want to combine into a single worksheet.
I want to combine rows based upon one column of data that each shares: worksheet 1: ID # Name State 1 Bob Ohio 1 Sue Utah 2 Joe Iowa Worksheet 2: ID# Location size 1 east 4 2 midwest 6 Combined Worksheet: ID# Name State Location Size 1 Bob Ohio east 4 1 Sue Utah east 4 2 Joe iowa midwest 6 I am struggling to figure this out. Any help would be much appreciated. Thanks |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Match & combine rows from 2 worksheets
VLOOKUP would help you here. Here's info on the function:
http://www.techonthenet.com/excel/formulas/vlookup.php Post back if you have problems getting the function to work. Dave -- A hint to posters: Specific, detailed questions are more likely to be answered than questions that provide no detail about your problem. "Doug" wrote: I have two worksheets w/ data that I want to combine into a single worksheet. I want to combine rows based upon one column of data that each shares: worksheet 1: ID # Name State 1 Bob Ohio 1 Sue Utah 2 Joe Iowa Worksheet 2: ID# Location size 1 east 4 2 midwest 6 Combined Worksheet: ID# Name State Location Size 1 Bob Ohio east 4 1 Sue Utah east 4 2 Joe iowa midwest 6 I am struggling to figure this out. Any help would be much appreciated. Thanks |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Match & combine rows from 2 worksheets
Sorry but I am not getting it. I don't see where VLOOKUP will do the combine
of the worksheets in the example on the link you provided. "Dave F" wrote: VLOOKUP would help you here. Here's info on the function: http://www.techonthenet.com/excel/formulas/vlookup.php Post back if you have problems getting the function to work. Dave -- A hint to posters: Specific, detailed questions are more likely to be answered than questions that provide no detail about your problem. "Doug" wrote: I have two worksheets w/ data that I want to combine into a single worksheet. I want to combine rows based upon one column of data that each shares: worksheet 1: ID # Name State 1 Bob Ohio 1 Sue Utah 2 Joe Iowa Worksheet 2: ID# Location size 1 east 4 2 midwest 6 Combined Worksheet: ID# Name State Location Size 1 Bob Ohio east 4 1 Sue Utah east 4 2 Joe iowa midwest 6 I am struggling to figure this out. Any help would be much appreciated. Thanks |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Match & combine rows from 2 worksheets
Does Bernie's response help?
-- A hint to posters: Specific, detailed questions are more likely to be answered than questions that provide no detail about your problem. "Doug" wrote: Sorry but I am not getting it. I don't see where VLOOKUP will do the combine of the worksheets in the example on the link you provided. "Dave F" wrote: VLOOKUP would help you here. Here's info on the function: http://www.techonthenet.com/excel/formulas/vlookup.php Post back if you have problems getting the function to work. Dave -- A hint to posters: Specific, detailed questions are more likely to be answered than questions that provide no detail about your problem. "Doug" wrote: I have two worksheets w/ data that I want to combine into a single worksheet. I want to combine rows based upon one column of data that each shares: worksheet 1: ID # Name State 1 Bob Ohio 1 Sue Utah 2 Joe Iowa Worksheet 2: ID# Location size 1 east 4 2 midwest 6 Combined Worksheet: ID# Name State Location Size 1 Bob Ohio east 4 1 Sue Utah east 4 2 Joe iowa midwest 6 I am struggling to figure this out. Any help would be much appreciated. Thanks |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Match & combine rows from 2 worksheets
Doug,
In cell D2 of worksheet 1, use the formula =VLOOKUP($A2,'Worksheet 2'!$A:$C,COLUMN()-2,False) Copy it to cell E2, then copy D2:E2 to match your data in worksheet 1. You can then copy columns D and E and pastespecial values, then get rid of worksheet 2, if you want. HTH, Bernie MS Excel MVP "Doug" wrote in message ... I have two worksheets w/ data that I want to combine into a single worksheet. I want to combine rows based upon one column of data that each shares: worksheet 1: ID # Name State 1 Bob Ohio 1 Sue Utah 2 Joe Iowa Worksheet 2: ID# Location size 1 east 4 2 midwest 6 Combined Worksheet: ID# Name State Location Size 1 Bob Ohio east 4 1 Sue Utah east 4 2 Joe iowa midwest 6 I am struggling to figure this out. Any help would be much appreciated. Thanks |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Match & combine rows from 2 worksheets
Thank you. With a little trial and error it work. My data was more
complicated then the example I posted so I had to figure out the formula. Thanks again!!! "Bernie Deitrick" wrote: Doug, In cell D2 of worksheet 1, use the formula =VLOOKUP($A2,'Worksheet 2'!$A:$C,COLUMN()-2,False) Copy it to cell E2, then copy D2:E2 to match your data in worksheet 1. You can then copy columns D and E and pastespecial values, then get rid of worksheet 2, if you want. HTH, Bernie MS Excel MVP "Doug" wrote in message ... I have two worksheets w/ data that I want to combine into a single worksheet. I want to combine rows based upon one column of data that each shares: worksheet 1: ID # Name State 1 Bob Ohio 1 Sue Utah 2 Joe Iowa Worksheet 2: ID# Location size 1 east 4 2 midwest 6 Combined Worksheet: ID# Name State Location Size 1 Bob Ohio east 4 1 Sue Utah east 4 2 Joe iowa midwest 6 I am struggling to figure this out. Any help would be much appreciated. Thanks |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Match & combine rows from 2 worksheets
"Doug" wrote: I have two worksheets w/ data that I want to combine into a single worksheet. I want to combine rows based upon one column of data that each shares: worksheet 1: ID # Name State 1 Bob Ohio 1 Sue Utah 2 Joe Iowa Worksheet 2: ID# Location size 1 east 4 2 midwest 6 Combined Worksheet: ID# Name State Location Size 1 Bob Ohio east 4 1 Sue Utah east 4 2 Joe iowa midwest 6 I am struggling to figure this out. Any help would be much appreciated. Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Adding Rows offsets to working rows across two worksheets | Setting up and Configuration of Excel | |||
Lookup? Match? pulling rows from one spreadsheet to match a text f | Excel Worksheet Functions | |||
MATCH function through multiple worksheets | Excel Worksheet Functions | |||
Link Rows Between Worksheets | Excel Discussion (Misc queries) | |||
Auto adjusting # rows between 2 worksheets | New Users to Excel |