Forum Discussion
Solved
MATCH or INDEX function
I have a spreadsheet with two columns labeled STUDENT IDs and STUDENT NAMES. I want to create a MATCH or INDEX formula in a block so when I input the student ID in one cell, the coresponding stude...
Hi Mike,
you can use the following formulas
For Student Name (B15)
=INDEX($B2:$B11,MATCH($A15,$A$2:$A$11,0))
For Overall Score (C15)
=INDEX($S2:$S11,MATCH($A15,$A$2:$A$11,0))
For Final Grade (D15)
=INDEX($T2:$T11,MATCH($A15,$A$2:$A$11,0))
Hope this helps
Thanks
Yury
Hello Wyn,
Thank you for quick response. My wife was able to figure it out using just the INDEX function:
=INDEX(A2:B11,A15,2)
It seems to work just fine this way too. Any drawbacks to using it just this way?
Thanks again!
Mike
Thank you for quick response. My wife was able to figure it out using just the INDEX function:
=INDEX(A2:B11,A15,2)
It seems to work just fine this way too. Any drawbacks to using it just this way?
Thanks again!
Mike
Hi Mike
The limitation is that it will pull back the student in row 1, row 2 etc. Because the student number is 1 and 2 etc. If the student number was 10 but they were in the 12th row of the table you would get the wrong data
The limitation is that it will pull back the student in row 1, row 2 etc. Because the student number is 1 and 2 etc. If the student number was 10 but they were in the 12th row of the table you would get the wrong data