Find max # and display name
 

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!

Find max # and display name
 

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




wrote in message
ups.com...
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!

Find max # and display name
 

On Sep 13, 4:07 pm, "Peo Sjoblom" wrote:
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

wrote in message

ups.com...



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!- Hide quoted text -

- Show quoted text -

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