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. INDEXB2B13MATCHTRUEA2A13D50 into a blank cell where you want to put the result see screenshot. INDEX data MATCH MIN range range match_type col_num data.
How to do a two-way lookup with INDEX and MATCH.
To create INDEX MATCH formula we need to replace MATCH with row_argument of INDEX. The syntax is as follows. 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. The INDEX function could now be rewritten like this since 2 is what MATCH found.