VLOOKUP using MAX returning multiple cells

are you OK with using VBA?

I could figure it out if I have to......yes

Here you go:

VLOOKUP_SOLVED.xlsx

This is assuming that the scores will never be the same and column M must be entered as an array function.







If this helped, feel free to express thanks with the star in the bottom left.

When I said this assumes that the scores will never be the same I am saying that if there is a tie for the highest score in a group it will only display the first person in the list to achieve that score.

Excellent! Thank you very much!!