I'm currently using a custom sort formula made with if statements:

=IF(E26="Aa";1;IF(E26="Ap";3;IF(E26="Ar";2;IF(E26="Os";9;IF(E26="Ts";10;IF(E26="Ps";11;IF(E26="Ss";12;IF(E26="J";4;IF(E26="Es";5;IF(E26="IL";6;IF(E26="Sp";8;IF(E26="Stl";8;IF(E26="El";17;IF(E26="Elh";18;IF(E26="Sl";19;IF(E26="Slh";20;IF(E26="Slc";21;IF(E26="Slch";22;IF(E26="LS";23;IF(E26="P";13;IF(E26="O";14;IF(E26="S";15;IF(E26="T";16;"X")))))))))))))))))))))))

The problem with this is that I can't use index match to sort because of the duplicates, wherever there is a duplicate, I get "#N/A" so I'm not able to replicate the table in a sorted form. Please let me know if there's any information I'm leaving out. Also, this is the index match formula that is giving me the errors:

=INDEX($B$31:$F$36;MATCH(ROWS($H$26:H26);$F$31:$F$36;0);1)

## Like this thread? Share it with others