vlookup duplicates

[par0016]

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

[protonLeah]

Sorry, but Excel formulas don't work on pictures.

[par0016]

excel forum.xlsx

Happy Now?

[canapone]

Hi,

in D1 you could try:

Please Login or Register  to view this content.

formula to be confirmed with control+shift+enter and copied down.

Regards

[sshishirkumar]

Please find the method which I used to name the column with duplicates differently. To sort the column, I just made it a table using "ctrl+T" so that the corresponding adjacent columns also change as per the sorting column.

[par0016]

Canapone that works perfect! Can you explain exactly how it works so I fully understand and can repeat it in the future?