Can a stunded by in two classes? If not then you can just add the class to
the student name in test sheet and filter...

Here is the VLOOKUP formula if this is an acceptable solution.
Enter in first available col in sheet 2
=VLOOKUP(A1,Sheet1!A:B,2,False) and copy down

Change Sheet1 to acutal name of your sheet...

"kilgore.of.trout" wrote:

Hello, I have two worksheets in this workbook. One worksheet has the names of
students that I have, what classses they are in, and their contact
information. The second worksheet has the names of the students that I have,
the tests they took, and all the answers they gave for each test.

A Hypothetical Example:

Worksheet 1:

Jerry Economics Classroom #104
Jimmy Finance Classroom #104
Natalie Economics Classroom #334
Amy Finance Classroom #104

Worksheet 2:

Jerry Test #1 Question 1: A
Question 2: A (...)
Jimmy Test #1 Question 1: C
Question 2: B (...)
Natalie Test #2 Question 1: B
Question 2: C (...)
Amy Test #1 Question 1: A
Question 2: C (...)

So, what I want to do is pull down the list in Worksheet 1 that has what
class they are taking and filter out only those students who are taking
Economics and somehow link that action to Worksheet two. So, that when I
move over to Worksheet 2 it will only display the test answers to the
students in my Economics class.