Dear T. Valko,
Many thanks for your suggested formular!

Really appreciate it!
Wilchong



T. Valko wrote:
Try this entered in C3 and copied down:

=INDEX(A$3:A$7,MATCH(SMALL(B$3:B$7,ROWS(C$3:C3)), B$3:B$7,0))

If there are duplicate numbers then a different approach will be needed.

The 2 data sets are assumed running in A3 and in B3 down, viz.:
In A3 down is: A, B, C, D and E
[quoted text clipped - 10 lines]

Wilchong

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...l-new/200805/1