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.