Excel Formula Index Match Highest Value Complete Guide

Best Math Formula website. Search anything about Math Formula in this website.

excel formula index match highest value. INDEX F3F11 MATCH MAX C3C11 C3C11 0. LARGE function finds the first highest match in range and returns the value to the MATCH function.

Basic Microsoft Excel Formulas Cheat Sheets Keyboard Shortcut Keys Hacks Microsoft Excel Formulas Excel Formula Microsoft Excel
Basic Microsoft Excel Formulas Cheat Sheets Keyboard Shortcut Keys Hacks Microsoft Excel Formulas Excel Formula Microsoft Excel from www.pinterest.com

To get the name of the nth largest value with criteria you can use INDEX and MATCH the LARGE function and a filter created with the IF function. I think I can do it with this formula but i dont know how. In the example shown the formula in cell G5 copied down is.

When we use MATCH it looks up for the value from the lookup column and return the cell number of that value.

INDEX data MATCH MIN range range match_type col_num data. INDEX F3F11 MATCH MAX C3C11 C3C11 0. Vlookup the next largest value and return its corresponding data with formulas. INDEXB2B13MATCHTRUEA2A13D50 into a blank cell where you want to put the result see screenshot.