Return the column header by searching for a specified value in a row

[lc06171970]

I need to look for a specific value in a row and return the name of the column

I'm trying to write a formula to look for "M1" in my table by row using student # and return the name of the column header.

Please see my sheet below. I appreciate any help. Thank you!!

[martindwilson]

=INDEX($C$2:$Q$2,MATCH("m1",INDEX($C$3:$Q$75,MATCH(15,$A$3:$A$75,0),0),0)) returns zumba for student 15

[lc06171970]

Thank you, thank you. I attempted the index function on my own and failed. This works great!

[lc06171970]

One last thing, what should I put in the formula to prevent it from returning #N/A when I copy down the formula? I just want a blank cell if there's no match.

Thank you again.

[martindwilson]

wrap it in iferror()
=iferror(INDEX($C$2:$Q$2,MATCH("m1",INDEX($C$3:$Q$75,MATCH(15,$A$3:$A$75,0),0),0)),"")

[lc06171970]

Thank you again!