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
1WORKSHEET 1
2Test Admin
Date		SSIDTest name2018
Overall
scaled
score		2018
Overall
performance
level
3Spring2018AN9347189Grade 3 English Language Arts6421
4Spring2018AN9347189Grade 3 Mathematics6842
5Spring2018GC1214706Grade 3 English Language Arts6331
6Spring2018GC1214706Grade 3 Mathematics6511
7Spring2018OE3636358Grade 4 English Language Arts7354
8Spring2018OE3636358Grade 4 Mathematics7685
9Spring2018SL2143749Grade 5 Science6712
10Spring2018SL2143749Grade 5 English Language Arts6782
11Spring2018SL2143749Grade 5 Mathematics6741
12

<colgroup><col style="width: 25pxpx"><col><col><col><col><col></colgroup><thead>
</thead><tbody>
</tbody>
Sheet1​
ABCDE
13WORKSHEET 2
14Test Admin
Date		SSIDTest Name2017
Overall
scaled
score		2017
Overall
performance
level
15Spring2017AN9347189Grade 3 English Language Arts6441
16Spring2017AN9347189Grade 3 Mathematics6511
17Spring2017BT8862463Grade 3 English Language Arts6461
18Spring2017BT8862463Grade 3 Mathematics6351
19Spring2017OE3636358Grade 3 English Language Arts6802
20Spring2017OE3636358Grade 3 Mathematics6882
21Spring2017SL2143749Grade 4 Social Studies6751
22Spring2017SL2143749Grade 4 English Language Arts6451
23Spring2017SL2143749Grade 4 Mathematics6481

<colgroup><col style="width: 25pxpx"><col><col><col><col><col></colgroup><thead>
</thead><tbody>
</tbody>
Sheet2​
ABCDEFGHIJ
26WORKSHEET
Merged
27Test Admin
Date		SSIDTest name2018
Overall
scaled
score		2018
Overall
performance
level		Test Admin
Date		Test Name2017
Overall
scaled
score		2017
Overall
performance
level		Matching
Status
28Spring2018AN9347189Grade 3 English Language Arts6421Spring2017Grade 3 English Language Arts6441Matching
29Spring2018AN9347189Grade 3 Mathematics6842Spring2017Grade 3 Mathematics6511Matching
30Spring2018GC1214706Grade 3 English Language Arts6331No Match
31Spring2018GC1214706Grade 3 Mathematics6511No Match
32Spring2018OE3636358Grade 4 English Language Arts7354Spring2017Grade 3 English Language Arts6802Matching
33Spring2018OE3636358Grade 4 Mathematics7685Spring2017Grade 3 Mathematics6882Matching
34Spring2018SL2143749Grade 5 Science6712No Match
35Spring2018SL2143749Grade 5 English Language Arts6782Spring2017Grade 4 English Language Arts6451Matching
36Spring2018SL2143749Grade 5 Mathematics6741Spring2017Grade 4 Mathematics6481Matching
37BT8862463Spring2017Grade 3 English Language Arts6461New row
38BT8862463Spring2017Grade 3 Mathematics6351New row

<colgroup><col style="width: 25pxpx"><col><col><col><col><col><col><col><col><col><col></colgroup><thead>
</thead><tbody>
</tbody>
Sheet3​



 

Excel Facts

Last used cell?
Press Ctrl+End to move to what Excel thinks is the last used cell.
You must log in or register to reply here.

Similar threads

C
  • Question
Index/Match multiple criteria and results
Replies
3
Views
599
Fluff
Fluff
GMC The Macro Man
  • Question
Filter columns with criteria
2
Replies
10
Views
411
Fluff
Fluff
R
  • Solved
Formula help required
Replies
4
Views
412
Fluff
Fluff
H
  • Question
Index Match VBA is very slow, and question to index match loop through column as well
Replies
1
Views
721
DanteAmor
DanteAmor
D
  • Solved
Combining two INDEX and MATCH functions
Replies
3
Views
261
felixstraube
F

Forum statistics

Threads
1,214,944
Messages
6,122,391
Members
449,080
Latest member
Armadillos

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