Pinterest Pixel

INDEX-MATCH Maximum Sales

The INDEX-MATCH formula cannot only look up values to the left and right of your data but... read more

Download Excel Workbook
John Michaloudis
Posted on

Overview

INDEX-MATCH Maximum Sales | MyExcelOnline INDEX-MATCH Maximum Sales | MyExcelOnline

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….

INDEX-MATCH Maximum Sales | MyExcelOnline

Download workbookIndex-Match-Max-Sales.xlsx

 

 

If you like this Excel tip, please share it
INDEX-MATCH Maximum Sales | MyExcelOnline INDEX-MATCH Maximum Sales | MyExcelOnline

Get Video Training

Advance your Microsoft Excel & Office Skills with the MyExcelOnline Academy!

Dramatically Reduce Repetition, Stress, and Overtime!
Exponentially Increase Your Chances of a Promotion, Pay Raise or New Job!

Learn in as little as 5 minutes a day or on your schedule.

Learn More!

Share to...