excel - VLOOKUP a value to the left of the Lookup_value -

To use Excel, use the VLOOKUP function to minimize the date Is there a way to find and maximal value?

< Div class = "post-text" itemprop = "text">

is correct with your layout (you can not do) and has been asked for reason. Index / match can be a suitable option, but to provide some detail, please try to say I30 to copy and cross to suit:

  = INDEX ($ H $ 6: $ H $ 26, MATCH (I27), I $ 6: I $ 26,0))