The INDEX-MATCH formula cannot only look up values to the left and right of your data but its versatility means that it can also lookup the largest values within an array.
Say that you had a list of Sales Reps in one array and their corresponding Sales Values in another array.
By nesting a MAX function, you can tell the formula to find the biggest Sales Value and return the Sales Rep corresponding to that.
Here is how….
DOWNLOAD WORKBOOK