Excel: index & match formula issue
I'm trying to use index & match formula but every time the message came out that I've a problem with this formula as attached picture.. simply, I need the to display the name of the highest score in the picture
I used the formula
=Index(B11:F11,MATCH(I11;B12:F12;0))
what is wrong ? please help :)
Solution 1:
I've sotted 2 possible issues.
- the formula in the image is actually
=INDEX(B11:F11,+MATCH(I11;B12:F12;0)) - you are using both , and ; as seperators use one or the other.
Try :
=INDEX(B11:F11,MATCH(I11,B12:F12,0))
Or
=INDEX(B11:F11;MATCH(I11;B12:F12;0))