Download Excel Workbook
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 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.
