Find the lowest value in a list linking it to a description.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

In an Excel spreadsheet I have a long list of values for which I would like
to determine the smallest value and also bring along with it the description
of the value. For example:
D4 25 (the smallest value in the list), A4 JoeB (value description)
 
=INDEX(A2:A200,MATCH(MIN(D2:D200),D2:D200,0))

--
Regards,

Peo Sjoblom

(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

finding a value with parameters 11
Find the smallest amount 1
How to look up a value in a list and return multiple corresponding 2
Identifing smallest numbers 1
match function? 1
First Value in Sorted Column is Not Sorted Properly 3
adding 4 smallest numbers greater than zero 3
How to determine the value from a list? 6

Back
Top