View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Wox Wox is offline
external usenet poster
 
Posts: 11
Default Using INDEX and MATCH in an Array

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