Match and Index for getting least marks

[sakmsb]

Hi all,

If i have 5 names in B column and their marks secured in Ccolumn.

I want to get the name of the person who scored least in D1 and the marks in E1.

Thanks for help!

[sakmsb]

=INDEX(B1:B5,MATCH(SMALL(C2:C5,1),C1:C5,0)) for getting name.

=INDEX(C1:C5,MATCH(SMALL(C2:C5,1),C1:C5,0)) for getting marks.

[sakmsb]

I was able to get it finally....

[JBeaucaire]

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.