H
harshaputhraya
Hi,
I am trying to use INDEX function to find the match for the maximum
score in a set of columns (say O2:O25,Q2:Q25,S2:S25 )and return the
corresponding name from column M.
I used the following formula
=INDEX(M2:M25,MATCH(MAX(O2:O25,Q2:Q25,S2:S25),O2:O25,0))
here it would return me the value only if the maximum score is present
in
O2:O25
But i need to match the the maximum score with more than one columns.
ie i want to match it with O2:O25,Q2:Q25,S2:S25.
I tried out this formula
=INDEX(M2:M25,MATCH(MAX(O2:O25,Q2:Q25,S2:S25),O2:O25,Q2:Q25,S2:S25,0))
But its not executing.
Please provide me a solution.
Appreciate ur time n help
Harsha
I am trying to use INDEX function to find the match for the maximum
score in a set of columns (say O2:O25,Q2:Q25,S2:S25 )and return the
corresponding name from column M.
I used the following formula
=INDEX(M2:M25,MATCH(MAX(O2:O25,Q2:Q25,S2:S25),O2:O25,0))
here it would return me the value only if the maximum score is present
in
O2:O25
But i need to match the the maximum score with more than one columns.
ie i want to match it with O2:O25,Q2:Q25,S2:S25.
I tried out this formula
=INDEX(M2:M25,MATCH(MAX(O2:O25,Q2:Q25,S2:S25),O2:O25,Q2:Q25,S2:S25,0))
But its not executing.
Please provide me a solution.
Appreciate ur time n help
Harsha