I am working with a table of sales numbers by date and by employee. The date is set up horizontally for the year and the employees are set up vertically. On a separate sheet I have a cell where I pick the date. I want the equations to reference this cell and change the top salesperson and the number of sales they have according to the date I select. I have only gotten it to work for a single column, not for variable columns dependent on the date. I have used INDEX(MATCH(MATCH functions with a MAX function, that's what has worked so far for Jan 1 but not for Jan 2 or later.

A MAX function that also takes into account a lookup for a specific column would be ideal. Any combinations I can use?