Learn to use VLOOKUP with MIN & MAX Functions

Learn to use VLOOKUP with MIN & MAX Functions

Learn to use VLOOKUP with MIN & MAX Functions

Learn to find Top & Least Sales Person Name with VLOOKUP function

You can nest a function as the lookup_value argument with VLOOKUP, to return an item relating to the lookup_value function.

In the pictured example, MIN and MAX are nested to return the name of the salesperson associated with those functions.

The formula in cell F6 is =VLOOKUP(MAX(C8:C19),C8:D19,2,0)
The formula in cell G6 is =VLOOKUP(MIN(C8:C19),C8:D19,2,0)

The VLOOKUP function’s fourth argument is range_lookup. For the MIN and MAX functions, the range_lookup is 0, which could have also been written as FALSE or simply omitted altogether. This deals with your desire and expectation that an exact lookup value will be found. In this example, you know that a specific minimum and maximum number will be found in the list in column A.


1

2 Responses

Show all responses
  1. prashant s. jawalagaddi
    July 17, 2014
    • Raghu Ram Alla
      August 5, 2014

Leave a Reply