I have two lists of employees whose shifts and tasks are dynamically adjusted on a daily basis. The raw data is pulled from an import, then the query is done for today's date. Once the employees who are working today are listed, their tasks should be transferred to another worksheet, in order to keep track of monthly statistic. The daily stats are important because an email is sent before each shift start to the employees who are working that day, in order to notify them of the task.

I've managed to connect the dynamic and static values in the second worksheet using a simple function:

=ARRAYFORMULA(IFERROR(VLOOKUP(A2:A998, 'Daily task stats'!D:F, 3, false)))

However, what I would like to have is for these values to be assigned to a column representing the date in question. I've listed the dates as a header row, and would like for the lookup function to notice the date, and use it as a column where to return the results.

It's important to have employees row static, so further calculations can be done. At least that's my train of thought for now, of course if there are some workarounds I'm happy to hear about them!

Sheet in question is: