If you have two lists in a sheet, and both of them have same value but in different order, how can you sort one list to match another list as below :

A column B column
E2. Bb4
D6. E2
Bb4. D6

Thank you
Note :sorry for I can’t attach file from my phon