On one sheet I have a list of students similar to what is below. I am wanting to pull data from another sheet using the student ID#'s.
Sheet #1
column A
Student ID#
1511
1596
1595
1550
1540
1559
1543
1525
1539
So on sheet #2 the search would match the student ID#'s from sheet #1 and then return the Room#'s of only those students that matched back to sheet #1.
Sheet #2
column A
Student ID#
1511
1533
1596
1595
2000
1550
1540
1559
1543
2695
1525
1539
1865
Sheet #2
column B
Room#
11
9
6
13
21
28
17
18
2
4
15
23
27
Any help is appreciated.
Justin
Bookmarks