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: