Function to Sort data based on value to the right

[hajiali]

A	10
B	5
C	20
D	1
E	13
F	15
G	18
H	2
I	6
J	7

<tbody>
</tbody>

Using the above table column A is an array Function that pulls data from another sheet which will Every time I sort Column B to Sort A to Z it always goes back to the normal Sort. I want column C to pull the data form Column A and List them based on the order of the number to the right so. So Results for Column C Should be as Follows:

D

H

B

I

J

A

E

F

G

C

<tbody>
</tbody>

 

[Toadstool]

As long as your data won't have duplicates, as in your example, then this will work:

	A	B	C
1	A	10	D
2	B	5	H
3	C	20	B
4	D	1	I
5	E	13	J
6	F	15	A
7	G	18	E
8	H	2	F
9	I	6	G
10	J	7	C

<colgroup><col style="width: 25pxpx"><col><col><col></colgroup><thead>
</thead><tbody>
</tbody>

hajiali​

Worksheet Formulas Cell Formula C1 =INDEX($A$1:$A$10,MATCH(AGGREGATE(15,6,$B$1:$B$10,ROW()),$B$1:$B$10,0)) <thead> </thead><tbody> </tbody>

<tbody>
</tbody>

 

[hajiali]

Thank you Toadstool. works Great