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

YouTube video

INDEX-MATCH Maximum Sales | MyExcelOnline

DOWNLOAD WORKBOOK

 

 

HELPFUL RESOURCES:

JOIN OUR FREE EXCEL COURSES BELOW
Click here to access these FREE Excel courses!

 

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