Sort a table with its values accordingly to another column

Hello, I have a table which have 2 columns:
Name & Grade.

I have another column which have the names that are sorted in some way(not alphabetically - just non logical sort).
I want to sort the 1st table which contains the columns & its grades accordingly to the additional column .

Here is an example attached
excel.JPG

If you don't mind using a helper column you could use MATCH to return the position of the names in the list and then sort the table on that column to give the desired result.

See attached.
This formula in H2 and copied down:

Formula:

Please Login or Register  to view this content.

Then just a case of sorting the table on column H.

Another way would be to lookup the values from the table into the list and use that as it's already in the correct order.
This in L2 and copied down would do that:

Formula:

Please Login or Register  to view this content.

BSB