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

Index-Match - Max Sales

HELPFUL RESOURCE:

Power Excel

If you like this Excel tip, please share itEmail this to someone

email

Pin on Pinterest

Pinterest

Share on Facebook

Facebook

Tweet about this on Twitter

Twitter

Share on LinkedIn

Linkedin

Share on Google+

Google+

Related Posts

Excel Subtotal Function – Include Hidden Val... What does it do? It returns a Subtotal in a list or database Formula breakdown: =SUBTOTAL(function_num, ref1) What it means: =SUBTOTAL(function number 1-11 includes manually-hidden rows & 101-111 excludes them, your list or range of data) ***Go to the bottom...
GETPIVOTDATA Function What does it do? A formula that extracts data stored in a Pivot Table Formula breakdown: =GETPIVOTDATA(data_field, pivot_table, , ,...) What it means: =GETPIVOTDATA(return me this value from the Values Area, any cell within the Pivot Table, ,...)   T...
Excel´s EndOfMonth function The EOMONTH (EndOfMonth) function in Excel is one that most people do not use because they just don't know that it exists. It is a great Excel function to use if you want to see when the month end date is from a current date's value. So if you have sales reps who make a sal...
Vlookup in an Excel Table What does it do? Searches for a value in the first column of a table array and returns a value in the same row from another column (to the right) in the table array. Formula breakdown: =VLOOKUP(lookup_value, table_array, col_index_num, ) What it means: =VLOOKUP(thi...