Entering edit mode
7.1 years ago
Grunir112
▴
10
I have two lists in Excel: List 1:
aa
33
2a
3de
432
s2e
3rr
List 2:
33
3de
432
s2e
2a
3rr
aa
(These are just an example. Actually, my list contains over 200 values per a column.) I want to arrange List 2 according to the List 1. In other words, I want List 2 to be exactly sorted as List 1 in Excel.
Can someone help me please? I have tried to use vlookup in Excel to arrange the two columns but it did not work.