Trying to compare data from one page to a specific range on another tab

[salvo69]

I have a list of tasks one one tab which are all labelled.
I also have a task rota on another tab listing the tasks under 5 columns for each day of the week

I am looking to pull through task a from the 5th November from a range that covers the 5-9th November (5 days). I already have a cell on each tab highlighting

[Fotis1991]

It would be better if you upload a small sample workbook to see how your data look like..

[salvo69]

I've now attached a file

One tab has today's date with a list of tasks and a blank field for who the task is allocated to

I want a formula to pull through the task owner from the rota tab linking to the correct date

[Fotis1991]

Try in B3 and copy down, this.

=INDEX('task rota'!$C2:$I2,MATCH(tasks!A3,'task rota'!B2:B5;0),MATCH(tasks!$A$1,'task rota'!$C$1:$I$1,0))