I have a very large spreadsheet that is constantly being added to. I have a
function that displays the max value of a particular column, but I also want
to display the name that coincides with it. Since the name is located in a
different column but same row number, is there a way to display it? (e.g.
A2="Mark", B2=97.8)
Any help would be greatly appreciated.