VLOOKUP With Max to Lookup Highest Value | Find the Min & Max Value in a Dataset Using VLOOKUP
Learn how to Vlookup the smallest value in a Excel by using a combination of the Min formula with the Vlookup formula. For more training videos please subscribe to Excel Dose:
Subscribe now: https://www.youtube.com/c/exceldose?s...
Formulas:
Max Value: =VLOOKUP(MAX(B6:B11),B:C,2,0)
Min Value: =VLOOKUP(MIN(B:B),B:C,2,0)