Converting text

[pkbravo]

these are my columns.

A B C

1 aa 26.9% Column c percentages are pulled fro
other
2 xx 25.1% sheets in the workbook. so th
cell refrences
3 oo 10.5% are in there. ex. 00!L58
4 nn 30.1%


now. i want to rank them from smallest to largest in another cell.
here are my formulas.

A B C

1 =small(c1:c4,1)
2 =small(c1:c4,2)
3 ..
4 ..

my problem is i cannot get the name to come into column B. vlookup
just puts a number in there. any help would be greatly appreciated.
:confused

 

[Guest]

Hi
try
=INDEX('other_sheet'!$B$1:$B$5,MATCH(C1,'other_sheet'!$C$1:$C$5,0))

 

[Bernd]

See my auto-sorting efficiency analysis at
http://www.bplumhoff.de/html/software.html

(use at your own risk - see disclaimer, please)

HTH,
Bernd