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 workbookIndex-Match-Max-Sales.xlsx
John Michaloudis is a former accountant and finance analyst at General Electric, a Microsoft MVP since 2020, an Amazon #1 bestselling author of 4 Microsoft Excel books and teacher of Microsoft Excel & Office over at his flagship MyExcelOnline Academy Online Course.