Assuming you have the value generated from SMALL in C1 try the below

C1 =SMALL($B$1:$B$144,ROW())
D1 =INDEX($A$1:$A$144,MATCH(C1,$B$1:$B$144,0))

I assume you dont have any duplicate values

If this post helps click Yes
---------------
Jacob Skaria


"Scott" wrote:

I have a range of 144 rows. A1:A144 contain names, B1:B144 contain values.
I've successfully used the SMALL formula to sort the data 1 through 144, but
I'd like to reference the corresponding names with the values. How do I do
that?