How to Use VLOOKUP to Return Min & Max Value in Excel

Summary

VLOOKUP is one of most powerful LOOKUP function in Excel. In this article you will learn how to find min and max value in Excel using VLOOKUP.

Purpose

Return Min and Max values from range or array

Syntax to Find Max Value

= VLOOKUP ( MAX ( number1, number2), table_array, col_index_num, [range_lookup])

Example Explanation

In the mentioned example, we have find out the Max Value and Name of person. Formula used in F6 & F7 is:

Syntax to find Min Value

= VLOOKUP ( MIN ( number1, number2), table_array, col_index_num, [range_lookup])

Example Explanation

In the mentioned example, we have find out the Min Value and Name of person. Formula used in F6 & F7 is:
scroll to top