Pull Top 10-values & thier dates

[LancerUWM]

So I have a list of values and corresponding dates in A and B. I know how to pull out the top 10 values into C, but I'm having trouble pulling the date of that value into D.
I'd like column C to basically show the A column values in order from highest to lowest, which I have no issues with, but how do I put the corresponding date in column D that matches the value from column A?

The attached file shows what the final result should look like, but I'm looking for help the best formulas to use for C and D. Thanks for any help you can provide!

 

[Mike H..]

So I have a list of values and corresponding dates. I know how to pull out the top 10 values into a separate array

Hi,

It's a lot easier if you give us a sample workbook. have a look at this one.

 

[LancerUWM]

My apologies Mike H. I just edited my original post since I accidentally posted it before my question was complete (first-time poster mistake). But it looks like your answer was spot on. I'll give this a try. Thanks!

 

[Mike H..]

My apologies Mike H. I just edited my original post since I accidentally posted it before my question was complete (first-time poster mistake). But it looks like your answer was spot on. I'll give this a try. Thanks!

Hi,

I never noticed it was your first post, welcome to Chandoo.

It wasn't quite correct but this one is.

 

[Khalid NGO]

Hi Lancer,

Welcome to the forum...

Try this for values in col c:
=INDEX($A$1:$A6,MATCH(LARGE($A$1:$A6,ROW()),$A$1:$A6,0),COLUMN(A1))

and this for dates in col d:
=INDEX($B$1:$B6,MATCH(E1,$A$1:$A6,0),COLUMN(A1))

copy down both...

Regards,