At first glance, it appears your parenthesis are in the wrong place.

Corrected:
=INDEX(Table1[Team],MATCH(MAX(Table1[[1]:[14]]),Table1[[1]:[14]],0))

--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Wox" wrote:

I am using the following formula on a table to return the item in the first
column where the MAX from a portion of the table is located.

=INDEX(Table1[Team],MATCH(MAX(Table1[[1]:[14]],Table1[[1]:[14]],0),1))

The portion that does not work is MATCH(114,$H$3:$U$14,0)

Can Match not be used to return the row for the index function when looking
up multiple rows and columns? If not, what formula should I be using here?

Thanks