Linking Lists and Filters between Worksheets in Excel

K

kilgore.of.trout

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.
 
S

Sheeloo

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...
 
K

kilgore.of.trout

Hello Sheeloo:

Thank you for your response. I never knew about VLOOKUP or HLOOKUP, so
thank you for educating me. However, this isn't really what I was looking
for. I'm hoping that there is a way I can link the two lists without having
to use a test sheet. I'd like to just filter Worksheet 1 and have the
corresponding data on Worksheet 2 filter aswell. I'm suspecting that this
function doesn't exist in Excel.

kilgore.of.trout
 
S

Sheeloo

No, it does not.

Excel provides basic building blocks which we can use to build our dream
house :)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top