Find max # and display name

  • Thread starter Thread starter Andersos
  • Start date Start date
A

Andersos

My setup and my issue:

I have Name1 in cell B2 and their score in cell C2. I have Name2 in
cell F2 and their score in G2. What I am trying to do is compare the
two scores, and then display the name of whoever is higher.

I think I am close with the formula =INDEX((B2,F2),MATCH(MAX(C2,G2),
(C2,G2))) but I am not getting a result.


Any help is appreciated!
 
If you look in help you can see it clearly states that MATCH and INDEX both
require arrays so you cannot pick 2 cells like that

Since you only have 2 cells to test you can use an IF function otherwise you
would be better off changing your layout

=IF(C2=MAX(C2,G2),B2,F2)


--


Regards,


Peo Sjoblom
 
If you look in help you can see it clearly states that MATCH and INDEX both
require arrays so you cannot pick 2 cells like that

Since you only have 2 cells to test you can use an IF function otherwise you
would be better off changing your layout

=IF(C2=MAX(C2,G2),B2,F2)

--

Regards,

Peo Sjoblom









- Show quoted text -
Click to expand...

That worked. I knew I was making things more complicated than I
needed.
 
Back
Top