Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Combining data using a primary key
I have 2 workbooks/worksheets with one column that is unique (the primary
key) that is shared across the 2 workbooks, but each workbook has some additional columns that the other does not have and are arranged in different order. I want to combine the data in one worksheet such that all of the data one each individual primary key row is combined into one worksheet. For eg: Workbook 1: Columns: Primary key, imaging value, test result Workbook 2: Columns: Primary key (with the same values as workbook 1 but in a different order (2, 4, 1, 38, etc), stress value, coefficient I want a worksheet that shows the imaging value, test result, stress value, and coefficient for each individual primary key (1, 2, 3, 38, etc). Thanks! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Combining data using a primary key
Vlookup...
Lookup Value= the cell address of your primary key Array= the range you're searching (does not have to be the entire table, and your PK needs to be the first column) Column Index Number= The number of columns counted over from your PK that you want the return answer from Range= False. You'll always want False for precise returns. Spreadsheets can get very large if you do enough of these. I'd recommend saving Values only once you get done or as you're adding new columns. -beth "Jamieson Bourque" wrote: I have 2 workbooks/worksheets with one column that is unique (the primary key) that is shared across the 2 workbooks, but each workbook has some additional columns that the other does not have and are arranged in different order. I want to combine the data in one worksheet such that all of the data one each individual primary key row is combined into one worksheet. For eg: Workbook 1: Columns: Primary key, imaging value, test result Workbook 2: Columns: Primary key (with the same values as workbook 1 but in a different order (2, 4, 1, 38, etc), stress value, coefficient I want a worksheet that shows the imaging value, test result, stress value, and coefficient for each individual primary key (1, 2, 3, 38, etc). Thanks! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
sorting 2 colums of numbers and incremening them down | Excel Discussion (Misc queries) | |||
Inserting a new line when external data changes | Excel Discussion (Misc queries) | |||
Excel Macro to Copy & Paste | Excel Worksheet Functions | |||
Combining Data multiple tabs | Excel Discussion (Misc queries) | |||
Sort pages? | Excel Discussion (Misc queries) |