Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Lookup Function help | Excel Discussion (Misc queries) | |||
Lookup Function Problems | Excel Worksheet Functions | |||
Complicated lookup function | Excel Worksheet Functions | |||
lookup function 1 | Excel Worksheet Functions | |||
How do I use 3 cells to create the string for a lookup function? | Excel Worksheet Functions |