I have a running sheet that calculates paid time off for payroll, it has a column for each pay date and rows for each employee and type of time off. I need a new sheet to populate with summary data based on the pay date.
For example, I entered the pay date on the summary sheet as 11/12/2018 I want C7 of the summary sheet to return the value shown in cell D7 on the accrual sheet, and so on and so forth for all employees having it automatically update based on whatever date I enter in cell C3 of the summary sheet.
Any suggestions on the best formula to accomplish this? I've been trying the INDEX MATCH function but can't get it to pull back the correct cells.
