Help With Index Match or VLookup _ Multiple Columns, Rows

K

kcompton

Board Regular
Joined
Mar 16, 2009
Messages
209
Hello -
In the example below, I have two worksheets: Worksheet 1 and Worksheet 2.
I am trying to merge/match data from Worksheet 2 into Worksheet 1 so that the result is WORKSHEET Merged.
Thank you for any help.

ABCDE
Test Admin
Date		SSIDTest name
Spring2018AN9347189Grade 3 English Language Arts
Spring2018AN9347189Grade 3 Mathematics
Spring2018GC1214706Grade 3 English Language Arts
Spring2018GC1214706Grade 3 Mathematics
Spring2018OE3636358Grade 4 English Language Arts
Spring2018OE3636358Grade 4 Mathematics
Spring2018SL2143749Grade 5 Science
Spring2018SL2143749Grade 5 English Language Arts
Spring2018SL2143749Grade 5 Mathematics

<colgroup><col style="width: 25pxpx"><col><col><col><col><col></colgroup><thead>
</thead><tbody>
[TD="align: center"]1[/TD]
[TD="align: center"]WORKSHEET 1[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]

[TD="align: center"]2[/TD]

[TD="align: center"]2018
Overall
scaled
score[/TD]
[TD="align: center"]2018
Overall
performance
level[/TD]

[TD="align: center"]3[/TD]

[TD="align: center"]642[/TD]
[TD="align: center"]1[/TD]

[TD="align: center"]4[/TD]

[TD="align: center"]684[/TD]
[TD="align: center"]2[/TD]

[TD="align: center"]5[/TD]

[TD="align: center"]633[/TD]
[TD="align: center"]1[/TD]

[TD="align: center"]6[/TD]

[TD="align: center"]651[/TD]
[TD="align: center"]1[/TD]

[TD="align: center"]7[/TD]

[TD="align: center"]735[/TD]
[TD="align: center"]4[/TD]

[TD="align: center"]8[/TD]

[TD="align: center"]768[/TD]
[TD="align: center"]5[/TD]

[TD="align: center"]9[/TD]

[TD="align: center"]671[/TD]
[TD="align: center"]2[/TD]

[TD="align: center"]10[/TD]

[TD="align: center"]678[/TD]
[TD="align: center"]2[/TD]

[TD="align: center"]11[/TD]

[TD="align: center"]674[/TD]
[TD="align: center"]1[/TD]

[TD="align: center"]12[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]

</tbody>
Sheet1​
ABCDE
Test Admin
Date		SSIDTest Name
Spring2017AN9347189Grade 3 English Language Arts
Spring2017AN9347189Grade 3 Mathematics
Spring2017BT8862463Grade 3 English Language Arts
Spring2017BT8862463Grade 3 Mathematics
Spring2017OE3636358Grade 3 English Language Arts
Spring2017OE3636358Grade 3 Mathematics
Spring2017SL2143749Grade 4 Social Studies
Spring2017SL2143749Grade 4 English Language Arts
Spring2017SL2143749Grade 4 Mathematics

<colgroup><col style="width: 25pxpx"><col><col><col><col><col></colgroup><thead>
</thead><tbody>
[TD="align: center"]13[/TD]
[TD="align: center"]WORKSHEET 2[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]

[TD="align: center"]14[/TD]

[TD="align: center"]2017
Overall
scaled
score[/TD]
[TD="align: center"]2017
Overall
performance
level[/TD]

[TD="align: center"]15[/TD]

[TD="align: center"]644[/TD]
[TD="align: center"]1[/TD]

[TD="align: center"]16[/TD]

[TD="align: center"]651[/TD]
[TD="align: center"]1[/TD]

[TD="align: center"]17[/TD]

[TD="align: center"]646[/TD]
[TD="align: center"]1[/TD]

[TD="align: center"]18[/TD]

[TD="align: center"]635[/TD]
[TD="align: center"]1[/TD]

[TD="align: center"]19[/TD]

[TD="align: center"]680[/TD]
[TD="align: center"]2[/TD]

[TD="align: center"]20[/TD]

[TD="align: center"]688[/TD]
[TD="align: center"]2[/TD]

[TD="align: center"]21[/TD]

[TD="align: center"]675[/TD]
[TD="align: center"]1[/TD]

[TD="align: center"]22[/TD]

[TD="align: center"]645[/TD]
[TD="align: center"]1[/TD]

[TD="align: center"]23[/TD]

[TD="align: center"]648[/TD]
[TD="align: center"]1[/TD]

</tbody>
Sheet2​
ABCDEFGHIJ
Test Admin
Date		SSIDTest name2018
Overall
scaled
score		2018
Overall
performance
level		Test Admin
Date		Test Name
Spring2018AN9347189Grade 3 English Language ArtsSpring2017Grade 3 English Language Arts
Spring2018AN9347189Grade 3 MathematicsSpring2017Grade 3 Mathematics
Spring2018GC1214706Grade 3 English Language Arts
Spring2018GC1214706Grade 3 Mathematics
Spring2018OE3636358Grade 4 English Language ArtsSpring2017Grade 3 English Language Arts
Spring2018OE3636358Grade 4 MathematicsSpring2017Grade 3 Mathematics
Spring2018SL2143749Grade 5 Science
Spring2018SL2143749Grade 5 English Language ArtsSpring2017Grade 4 English Language Arts
Spring2018SL2143749Grade 5 MathematicsSpring2017Grade 4 Mathematics
BT8862463Spring2017Grade 3 English Language Arts
BT8862463Spring2017Grade 3 Mathematics

<colgroup><col style="width: 25pxpx"><col><col><col><col><col><col><col><col><col><col></colgroup><thead>
</thead><tbody>
[TD="align: center"]26[/TD]
[TD="align: center"]WORKSHEET
Merged
[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]

[TD="align: center"]27[/TD]

[TD="align: center"]2017
Overall scaled score [/TD]
[TD="align: center"]2017
Overall
performance
level[/TD]
[TD="align: center"]Matching
Status[/TD]

[TD="align: center"]28[/TD]

[TD="align: right"]642[/TD]
[TD="align: right"]1[/TD]

[TD="align: center"]644[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]Matching[/TD]

[TD="align: center"]29[/TD]

[TD="align: right"]684[/TD]
[TD="align: right"]2[/TD]

[TD="align: center"]651[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]Matching[/TD]

[TD="align: center"]30[/TD]

[TD="align: right"]633[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]No Match[/TD]

[TD="align: center"]31[/TD]

[TD="align: right"]651[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]No Match[/TD]

[TD="align: center"]32[/TD]

[TD="align: right"]735[/TD]
[TD="align: right"]4[/TD]

[TD="align: center"]680[/TD]
[TD="align: center"]2[/TD]
[TD="align: center"]Matching[/TD]

[TD="align: center"]33[/TD]

[TD="align: right"]768[/TD]
[TD="align: right"]5[/TD]

[TD="align: center"]688[/TD]
[TD="align: center"]2[/TD]
[TD="align: center"]Matching[/TD]

[TD="align: center"]34[/TD]

[TD="align: right"]671[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]No Match[/TD]

[TD="align: center"]35[/TD]

[TD="align: right"]678[/TD]
[TD="align: right"]2[/TD]

[TD="align: center"]645[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]Matching[/TD]

[TD="align: center"]36[/TD]

[TD="align: right"]674[/TD]
[TD="align: right"]1[/TD]

[TD="align: center"]648[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]Matching[/TD]

[TD="align: center"]37[/TD]
[TD="align: right"][/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]646[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]New row[/TD]

[TD="align: center"]38[/TD]
[TD="align: right"][/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]635[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]New row[/TD]

</tbody>
Sheet3​



 

Excel Facts

Remove leading & trailing spaces
Save as CSV to remove all leading and trailing spaces. It is faster than using TRIM().
You must log in or register to reply here.

Similar threads

GMC The Macro Man
  • Question Question
Count with Multiple Criteria - Follow up
Replies
2
Views
210
myall_blues
myall_blues
J
  • Question Question
Power Query editor OR VBA to extract data from Grants.gov
Replies
3
Views
380
Jagadeshrao
J
C
  • Question Question
Index/Match multiple criteria and results
Replies
3
Views
789
Fluff
Fluff
GMC The Macro Man
  • Solved
Filter columns with criteria
2
Replies
14
Views
780
Fluff
Fluff
GMC The Macro Man
  • Solved
How to count with Multiple Criteria
Replies
6
Views
238
dreid1011
dreid1011

Forum statistics

Threads
1,224,765
Messages
6,180,843
Members
453,001
Latest member
coulombevin

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top