Custom Sort With 3 Keys

Hi all,
I have a range which I am trying to custom sort with 3 keys.
I am trying to construct two string arrays from two different columns on a sheet and use these to create two custom lists which I can sort with - the third key just sorting via a standard key.

However, I cannot get the range to sort in the exact order of my customer lists and I believe it is just sorting ascending.

Here is my code below:

Please Login or Register  to view this content.

Hi all,
I might be over complicating my request, hence no replies.
What I basically want to do is sort a range by two custom lists.
Can anyone advise me on how this can be done?