Aligning different columns

[cynthia74]

Hello!

I have a problem with sorting.

I have two files : the first one has one column of French words placed in a certain order.
The second file has two columns: one with the same French words in a different order than in the first file and a second column with the Chinese translation of those French words.

I need to put the Chinese translation in the second file in the same order as the French in the first file.

I am uploading two test files so you can understand what I mean in case my explanations aren't clear.Second file with French in different order and chinese translation.xlsFirst file with only French in right order.xls

I hope the upload worked...

Thanks for your help!!
Cynthia

[Md Aejaz]

http://office.microsoft.com/en-us/ex...010222142.aspx

http://www.exceltip.com/st/Sorting_b...2007/1393.html

hope this 2 custome sort URl kink will help u.

[kvsrinivasamurthy]

Pl see the attached files. Array formulas are used.
Both the files should be in same folder.

[cynthia74]

I'm so sorry to answer so slowly... I found the solution (none worked like I needed)...

I numbered and sorted the columns and cut paste into files and expanded the sort... it was just as simple as that.... jeez!!! ))) lol

Thanks for always being there for us non-techies!!!!