modify MATCH code

[erutherford]

I have used this code before and it functions fine. I want to modify it for another use.

original code

{=IFERROR(INDEX(Entry,MATCH(1,(B56=Div)*(B57=Model)*(MAX(IF(Div=B56,IF(Model=B57,Pts)))=Pts),0)),"x")}

I no longer need "model", so I thought I could just removed it, but it's not functioning. It does returns the "x".

Modified code:

{=IFERROR(INDEX(Pts,MATCH(1,(B61=Div)*(MAX(IF(Div=B61,Pts)))=Pts),0),"x")}

I have 3 columns "index",'Div" & "pts", the code should return the name in "index" column, based on "Div" criteria in B61 with the highest score in "pts".

thanks

 

[Fluff]

Try
=IFERROR(INDEX(Indx,MATCH(MAX(IF(Div=B61,pts)),pts,0)),"x")

change value in red to match the name of your "Index" column

 

[erutherford]

Thanks Fluff! I'll research what the purpose of the "*" does, since that looks like what the problem was.

 

[Fluff]

You're welcome

The * is equivalent to And