Sorting a data list by another data list

[Daniele]

Hello,
i'm quite a newbie to Excel, so forgive if the solution to my problem is evident, but i could not figure it out at the moment, so i'm asking here in hope to obtain some help.
Let's say you have a sorted list of numbers, to which is associated another list like this:

1 a
2 b
3 c
4 d
5 e
6 f
7 g
8 h

Now i want to sort this list throgh another list, with the same numbers, but with a different order:

3
5
1
7
8
6
2
4

At the same time i would like to keep the original association between the two lists, so that, in the end, i would find such a situation:

3 c
5 e
1 a
7 g
8 h
6 f
2 b
4 d

I've not yet figured out how to solve this problem. The 'data sort' seems to be the most immediate way, but i haven't found an option to sort by confrontation with another list.
My version is 2003.
Thank you in advance for any help.

[martindwilson]

you can just use a vlookup see attached

[Richard Buttrey]

Hi,

With your original data in A1:B8, enter your desired order in C1:C8. In D1 enter

Please Login or Register  to view this content.

and copy down
Column D gives the result.

HTH

[Daniele]

Thanks to both, solved.