Sort numbers & drag across corresponding column text

Hi Guys,

I've stumped myself and would really appreciate any help you could provide me.

I'm trying to find a formula which will sort my numbers in descending order, but also bring across the appropriate text corresponding to that number. This needs to be a formula because I need to use it in multiple sheets so it updates when new data is dumped in.

In the attachment I have my data in column C and D. And in column F and G it has the result i'm looking for.

I have tried a formula which contains Index, Match and Count If but i can't seem to get it to work. Hopefully you can help!

Cheers
Rooboyz