Formula to Display Name and Total Sales Weekly

[RankSinatra]

******** name="google_ads_iframe_/22152718/sws-hb//mrexcel.com//in_post_0" width="300" height="250" title="3rd party ad content" id="google_ads_iframe_/22152718/sws-hb//mrexcel.com//in_post_0" frameBorder="0" marginWidth="0" marginHeight="0" scrolling="no" style="border: 0px currentColor; vertical-align: bottom;">*********>

I have a table with dates in the horizontal axis and names in vertical. I need a function that would give me both the name of the top salesperson for a week ending in a selected date and their total sales for that period.
For example, for the same information by day I used these 2 equations:
=MAX(INDEX('Yearly Input - AP'!C4:NN36,0,MATCH(D5,'Yearly Input - AP'!C3:NN3,0))) <-Max sales on that date
=IFERROR(INDEX('Yearly Input - AP'!A4:A36,MATCH('Cover Tab'!E7,INDEX('Yearly Input - AP'!C4:NN36,0,MATCH(D5,'Yearly Input - AP'!C3:NN3,0)),0)),"No data found") <- Name of salesperson

Range is all dates in the coming year, C4:NN36
Date referenced is chosen in cell on same sheet, D5

Need name and total max sales per week?​

 

[Fluff]

Duplicate of https://www.mrexcel.com/forum/excel...me-sales-number-lead-cashier.html#post4990644

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread. Per forum rules, posts of a duplicate nature will be locked or deleted (rule 12 here: Forum Rules).

If you do not receive a response, you can "bump" it by replying to it again, though we advise you to wait 24 hours before doing so and not to bump a thread more than once a day.