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!