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

Share on Facebook

Tweet about this on Twitter

Share on LinkedIn

Share on Google+

Related Posts

Advanced SUMPRODUCT Function: Conditional Sum Another great way that you can use the SUMPRODUCT function is to create a conditional sum criteria.For example, you may want to find out how much sales were made above the $3,000 transactional level.  See how easy it is with this quick SUMPRODUCT example.DOWNLOAD WORKBOOK...
SUMIF Function: Introduction The SUMIF function is used widely amongst spreadsheet users as it is a simple Excel function.  It allows you to Sum the values in a range that meet a criteria that you specify.So if you want to Sum a range of sales values that are above $3,000 then this is the best Excel func...
Calculate Elapsed Time in Excel When you have two points in time and you want to calculate the amount of time elapsed, then you will need to use Excel´s TEXT functionSometimes data gets dumped into Excel with the following date & time format:24/01/2015  19:48:00.Using the TEXT function and enter...
Free Excel Formulas & Functions Webinar Train... In this popular Free Excel Formulas & Functions Webinar Training which goes for 60 minutes you will learn the MUST KNOW Excel Formulas to ADVANCE your Excel skills!You will learn the following Excel Formulas & Functions: IF, SUMIF, VLOOKUP, INDEX/MATCH + MORE...!P...