Get the Maximum Sales using the INDEX & MATCH formula in Excel

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. -------------------- Click here to download the Excel workbook & practice over at our blog: ------------ ?? MyExcelOnline Academy Online Excel Courses ? 1,000 Microsoft Excel video training tutorials & support covering Formulas, Macros, VBA, Pivot Tables, Power Query, Power Pivot, Power BI, Charts, Financial Modeling, Dashboards, Word, PowerPoint, Outlook, Access, OneNote, Teams & MORE... ? OUR BEST EXCEL RESOURCES ? ------------ Feel free to comment and ask questions about this Microsoft Excel tutorial below and we will get back to you with the answer ASAP! If you enjoyed the video, please give a thumbs up, comment, share. Do not forget to SUBSCRIBE to this channel to get our new Microsoft Excel tutorials delivered straight to you each week! Thank You :) Cheers, JOHN MICHALOUDIS Chief Inspirational Officer & Microsoft MVP ❤️ Let’s connect on social ❤️ #MyExcelOnline