indexing - Excel index or vlookup? -
i'm trying report shows top 10 senders of emails each month. on worksheet 1, have in column date jan-2015, feb-2015 etc, in column b list of email addresses, , in column c total number sent users in each month. on worksheet 2, i'd results show have date ddl, jan-2015, feb-2015 select , on. what (if it's possible) when select date on worksheet 2, pull top 10 highest amount of emails sent , corresponding user , when change date i'd information update. an example of spreadsheet this. 1 i'm working on has alot more information should give general idea. 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 then on worksheet 2, a1 ddl select date ranges. a...