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.

Comments

Leave a Reply

Your email address will not be published. Required fields are marked *

fifteen − seven =

This site uses Akismet to reduce spam. Learn how your comment data is processed.