Gunners

They're U18s

Kidding of course. I was messing around with a vlookup before bed and didn'tclear it. I wanted it to index the names of the player who has received the highest and lowest score.

I'm not the strongest with vlookups, but I think I have it right. However, sheets tells me there's no value of 10 in the range I've provided. So, I was using that section as a mini test.

Before that point though, when I included the entire table, it kept pointing specifically to row 11 and was indexing information from that row only. When I changed it to only include the player names and the other columns, I started to get the no 10 value found.

It was bewildering

It looks like I was being a little too ambitious. I think I was trying to find a single value from multiple columns and then use a vlookup in reverse and it just didn't know what to do. I tried to use an array in the range to point to E4:H43 first, then to D4:D43, but that also failed.

I managed to find out about xlookup which is apparently more robust. However, I can only use it for a single column. There probably is a way to fandangle it, but a lot of the information is kinda washing over me and a little out of my comprehension at this point, lol.

I'm going to have the xlookup just focus on the overall column instead to find the highest and lowest values and then return the player name value. I could probably have different high and low stats per comp. I'll see how I go.

I did see that. I think I'll include it as well, but with the overall scores

Thanks :)