Help with lookup function
I have two worksheets in the same workbook. Sheet one includes data similar to:
Person Average
Colin 72.15
Scott 66.21
John 58.95
In Sheet two I have a function that lets me know what the maximum average
is. My question is, I also want to know what person has the maximum average.
Example:
Max. Average = 72.15
Person = ????
This is just a short example I have 200 people on my list.
Thanks,
Scott
|