=MATCH() returns wrong value

Question

Why doesn't this work? I have the share of votes of different Finnish parties in the City of Jyväskylä in every region.

Every row shows one region, every column has the share of votes of every party. I'd like to add a column where Google Spreadsheet would find out which column has the maximum value on that particular row and then return the text on the header row of that column.

In other words I'd want to add "The biggest party column" that would show which party got the biggest share of votes in every region.

I think that should be possible using =max()-function to find out the maximum value, then using =match() function to give the column index number of the cell that has the biggest value on row and finally use =index()-function to return the party's name from header row.

Any ideas what I'm doing wrong?

Answer 1

MATCH needs a third argument of zero for your case (to get an exact match). Change formula to

=INDEX(C$1:M$1,MATCH(MAX(C2:M2),C2:M2,0))