Forum Discussion

heyaburt's avatar
heyaburt
Copper Contributor
May 11, 2017
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...
Formulas & Functions
Need Help
  • Yury Tokarev's avatar
    Yury Tokarev
    May 12, 2017

    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

     

Yury Tokarev's avatar
Yury Tokarev
Iron Contributor
May 12, 2017

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

 

heyaburt's avatar
heyaburt
Copper Contributor
May 12, 2017
Thank you, Yury. It helps out quite a bit!

I appreciate it!

Mike

Resources