I am trying to arrange a 2x5 matrix in descending order using one of the columns. However, I want the second column to remain coupled with its adjacent value. Currently I am sorting Column A in Column C using the large function and then I use vlookup to place its counterpart from Column B in Column D. However, due to the non unique numbers in Column A I cannot get each value of Column B represented in Column D. I am trying to make Column D give the values I have shown in Column F (the C, F and B, D, and I can be interchangeable, I just want each letter represented).

See the attached Example

Capture.PNG

Any help would be great. I am looking to do this with formulas not code. If you have a different way of doing it that would work but I am also curious as to whether or not it can be done similar to the way I tried. Thanks