This Microsoft Excel video shows how to return the name of the highest scorer from a list of people using the match and Index function.
It is possible to reference an array to return the name of a specific person based on a condition of their score in Excel.