All, I have two spread sheets, on sheet 1 we have 5 columns. Column A has a the Key. Sheet two has 3 columns with column A as the Key matching sheet 1. What I'm trying to do is move information from sheet 2 (Column B and C) into column D and Column E on sheet one based on the Primary Key that is on both sheets in column A. See attachment. There are several thousand rows so an automated process would be greatly appreciated. This one is out of my scope of skills. Thanks!
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Excel - combining columns with a Primary Key
- Thread starter unmlobo
- Start date
SkipVought
Programmer
Hi,
Assuming that 1) row 1 contains headings and 2) row 2 is the first row of dara on sheet1...
[tt]
D2: =INDEX(Sheet2!B:B,MATCH(A2,Sheet2!A:A,0),1)
E2=: =INDEX(Sheet2!C:C,MATCH(A2,Sheet2!A:A,0),1)
[/tt]
Skip,
[sub]
![[glasses]](/data/assets/smilies/glasses.gif "[glasses] [glasses]")
Just traded in my OLD subtlety...
for a NUance!![[tongue]](/data/assets/smilies/tongue.gif "[tongue] [tongue]")
[/sub]
"The most incomprehensible thing about the universe is that it is comprehensible" A. Einstein
Assuming that 1) row 1 contains headings and 2) row 2 is the first row of dara on sheet1...
[tt]
D2: =INDEX(Sheet2!B:B,MATCH(A2,Sheet2!A:A,0),1)
E2=: =INDEX(Sheet2!C:C,MATCH(A2,Sheet2!A:A,0),1)
[/tt]
Skip,
[sub]
Just traded in my OLD subtlety...for a NUance!
[/sub]"The most incomprehensible thing about the universe is that it is comprehensible" A. Einstein
- Status
Similar threads
