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

J

JoeB

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)
 
P

Peo Sjoblom

=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)
 
Top