Functions (search within search result) reply to this please

N

Nick

I am trying to search within a search result to give me a particular result
Refer "desired result" below. For example, from a group of 3 students, 3
tests were given. I would like to search each student by Student ID and for
that particular Student, I would like to show the score for one of the tests.
Can anyone assist me in using functions to do this?

Data:

Sudent Test Score
Student1 Econ 12
Student1 English 41
Student1 Math 21

Student2 Econ 11
Student2 English 23
Student2 Math 12

Student3 Econ 22
Student3 English 44
Student3 Math 41


Desired Result:
Student Test Score
Student1 English 41
 
T

T. Valko

Try this...

A2:A20 = student names
B2:B20 = test
C2:C20 = score

Use cells to hold your search criteria...

E2 = Student1
F2 = English

=SUMPRODUCT(--(A2:A20=E2),--(B2:B20=F2),C2:C20)
 

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