I am using Excel 2013 on Windows 7.
I have 2 columns of data like this:
Name Value
aaa 1
bbb 123
ccc 81
... ...
I need to sort this data into specific order that looks like random so I cannot use basic criteria like alphabet to sort it. Number of lines is quite high so it does not make sense to do the ordering manually.
There are no duplicates in the Name column
.
I tried using Custom list
of Excel sorting tool but apparently my list is too long to fit into it. (The list gets cut off at some point.)
I have third column with the desired order for data:
Desired order
bbb
aaa
ccc
...
How can I sort the data I have into order given by the third row?
vlookup()
to get the value.