Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Merging Data
I have two excel spreadsheets in 2003. I want to search the main spreadsheet
for certain ID code. Once that code is found to dump the associated information that has 10 separate columns on one row from the second spreadsheet into new columns in the main sheet. Example: Main sheet has 15 columns of personal information with a keycode. Let's says the keycode I want is 129. In the other sheet I have name, address, province, country, postal code and key codes. I want to take the customer info associated with key code 129 and dump into the main sheet in all places that has the key code 129. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Merging Data
Let's say the Main worksheet has data in rows 1 to 220 and columns A to 0:
so the table $A$1:$O$220 and that the sheet is called Main. As long as the key in in the first column we can use VLOOKUP On the second sheet in A1 you have entered the key to be found (129) In a cell to the right of this enter =VLOOKUP($A1,Main!$A$1:$O$220,2,FALSE) to extract the data from column 2 of the table from the row with key 129. To get data from column 3 use =VLOOKUP($A1,Main!$A$1:$O$220,3,FALSE) If the key is not in the first column we need to you MATCH and INDEX so please tell us how the data is arranged if VLOOKUP does not work for you best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "John" wrote in message ... I have two excel spreadsheets in 2003. I want to search the main spreadsheet for certain ID code. Once that code is found to dump the associated information that has 10 separate columns on one row from the second spreadsheet into new columns in the main sheet. Example: Main sheet has 15 columns of personal information with a keycode. Let's says the keycode I want is 129. In the other sheet I have name, address, province, country, postal code and key codes. I want to take the customer info associated with key code 129 and dump into the main sheet in all places that has the key code 129. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help with merging data | Excel Worksheet Functions | |||
Merging multiple columns of data into one column of data | Excel Discussion (Misc queries) | |||
Merging data | Excel Discussion (Misc queries) | |||
Merging data | Excel Discussion (Misc queries) | |||
Should Merging workbooks pick up new data or only edited data? | Excel Worksheet Functions |