reg. sorting of to items and their related fields

dear all,
i m attaching an excel file.column A and B are related.column C and D are related.the entries in column A and C are same but not in order.now i want to sort so that entry in cell A=cell C and the related entry in cell in B,D .

sorry martindwilson,i m attaching another file.

Hi xpushkar

find the attatched file with value corrosponding to the column A&B from C&D are shown in G&H

sir,
i m attaching one more file for this purpose.

Hi xpushkar

there is space before the text in column C. Use this formula in Cell G2

=IFERROR(VLOOKUP($A2,INDEX(TRIM($C$2:$D$19835),0),COLUMN(A$1),0),"")

any paste on cell range G2:H19459

in other case remove the spaces from column C. for this purpose select column c and use Ctrl+H

after removing spaces use in G2 and apply on range G2:H19459

=IFERROR(VLOOKUP($A2,$C$2:$D$19835,COLUMN(A$1),0),"")

Hi xpushkar

as i wrote earlier there are spaces before text in column C, the trim function is removing these spaces. so these become equal to text in column A. the index is convrting the range in trim function into a list and vlookpu is picking the match vale from that list.

Use the evaluate formula function from the formula tab for more understanding.