Current Scenario:

A1: USB 2.0, B1: USB, C1: Type A
A2: FW, B2: FW400
A3: Serial, B3: DB-9, C3: RS-232

I have another list.

F1: TypeA
F2: DB-9

G1: USB 2.0
G2: RS-232
G3: FW400

H1: USB
H2: Serial
H3 FW

What I want is to sort A1:C3 row wise, and it will compare with column
F,G & H.

if column F matched with row1 then a particular value should be
appear.
In other words no matter what data lies in A1:A4....its order should
be like F1:H1

Thanks in advance.