Need help with INDEX/MATCH formula

I'm working on a golf outing scoresheet to make it faster after the scramble. I've gotten a lot done (with help from this forum) but I'm running into another issue. In cells C26:U26, I want to show the Team Name (column A) that has the score matching the result of C30:U30. The issue I'm having is that the Skins checkbox (column B) also has to be checked. This checkbox returns a TRUE/FALSE in column Z. If more than one team wins the skin (lowest score & checkbox checked), I want it to return NO SKINS.

After this calculation is complete, I would like a function to count how many times each of these names from column A are returned, and populate the winner of the skins in X15:X25. The winner will have to have won the most amount of skins (highest number of returns in C26:U26). I'd like it to exclude the "NO SKINS" return from the count also. If there is a tie (more than one of the highest number), multiple people will win the skins and I'd like all of their team names to be populated in X15:X25.

Thanks for all of your help!

That didn't quite do what I wanted. I reattached the file. So for example, even though row 3 shows the lowest value (1), the checkbox isn't checked. The result for C26 should be "B" since it is the lowest value of row C that has the box checked.

That did it, thanks! I may be uploading these files incorrectly so I apologize.

One last favor. I want to calculate the skins game winner and post that in X15:X25. There may be more than one winner if they have an equal amount of skin holes won. So the formula would have to count how many times the winning name is calculated in row 26, and then post the name(s) over in X.

Thanks again!

Try this:

Column AC has COUNT of Team winners

=COUNTIF($C$26:$U$26,A3)

Column AD ranks them allowing for duplicates

=IF($AC3<>0,(COUNTIFS($AC$3:AC3,AC3)-1)*0.001+$AC3,"")

In X15

=IFERROR(INDEX($A$3:$A$26,MATCH(LARGE($AD$3:$AD$24,ROWS($1:1)),$AD$3:$AD$24,0)),"")

Drag down

John,

I loaded up a bunch of scores. As you can see, it returned Teams A, E, & C as the skins winners. But if you look at row 26, Team C has the most skins, and should be the only winner posted in Y15 (I moved it from X in the previous upload). What can be done to fix this?

Thanks!

Sorry about the alignment problem: shouldn't work late at night! Thanks to JeteMc for the correction. Looks OK now.

You guys are awesome! Thank you very much for your help!!