title: Excel index or vlookup?
body: <p>I'm trying to do a report that shows the top 10 senders of emails each month.</p>
  
  <p>On worksheet 1, I have in column A the date Jan-2015, Feb-2015 etc, in column B a list of email addresses, and in column C a total number sent by those users in each month. On worksheet 2, where I'd like the results to show I have a date DDL, with Jan-2015, Feb-2015 to select from and so on. </p>
  
  <p>What I would like (if it's possible) is when I select the date on worksheet 2, for it to pull up the top 10 highest amount of emails sent and the corresponding user and when I change the date I'd like that information to update.</p>
  
  <p>An example of the spreadsheet would look something like this. The actually one I'm working on has ALOT more information but this should give the general idea.</p>
  
  <pre><code>date    sender  amount sent
  Jan-15  john@email.com  12
  Jan-15  david@email.com 23
  Jan-15  claire@email.com    45
  Jan-15  paul@email.com  56
  Jan-15  ross@email.com  78
  Feb-15  dayna@email.com 89
  Feb-15  ben@email.com   65
  Feb-15  gary@email.com  32
  Feb-15  jim@email.com   15
  Mar-15  james@email.com 48
  Mar-15  luke@email.com  78
  Mar-15  rebecca@email.com   96
  </code></pre>
  
  <p>Then say on worksheet 2, A1 would be my DDL to select the date ranges.</p>
  
  <p>Any help would be greatly appreciated as I've been banging my head against the desk trying to figure this one out.</p>
  
  <p>Thanks in advance
  Dave</p>
  
  <p><strong>EDIT: I've now been asked to add an additional column for time spent which currently looks like this</strong></p>
  
  <p><a href="http://imageshack.com/a/img537/1409/CTwrcx.png" rel="nofollow">http://imageshack.com/a/img537/1409/CTwrcx.png</a></p>
  
  <p>When I use the formula</p>
  
  <p>=LARGE(IF($A$5:$A$9=$H$3,$D$5:$D$9),F5)</p>
  
  <p>it just puts them in size order but doesnt reflect the sender. I've had ago at index/match but couldn't get it to work.</p>
  
  <p>Can you advise what im doing wrong?</p>
  
  <p>Many thanks
  Dave</p>