Get adjacent value of a cell having minimum value in a range

If you have a range of values in one column and the corresponding names of individuals in another column.  You may want to find out the name of the person having the least value in the column of numbers.

For e.g. If you have data like this.  And you would like to find out the name of the person having the least value in column B.

Then you can use this formula -

=INDEX(A1:A100,MATCH(MIN(B1:B100),B1:B100,0))

In C1 put the above formula.  The result is as shown -

So the name Joe will appear since he has the least value in column B, compared to the rest.

Users are saying about us...

  1. Almost what I am looking for, how do I use a named range in this. For Example. I have a 3 column range. How do I find the max value in Col 3 and display the corresponding value from Col 1. I know how to do this using rows and columns, but somehow I can’t get the syntax right for a named range.

Leave a Reply to Vinod Cancel reply

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

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

Terms and Conditions of use

The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.

Visit Us On TwitterVisit Us On FacebookVisit Us On Google PlusVisit Us On Youtube