List of things to do

Hi,

I really need help with a formula. Hope some of you could help me out.

In Sheet 1 i have a list of project categories in column A. In column B i have tasks within the different projects.
In column C I have the start week of this task and in column D i have the end week of the task.

In sheet 2 I would like to make a list of all tasks happening the actual week.
I then need both project in column A and the task in column B.

Hope this was clear.


Do anyone know the magic formula?

All the best!

TB.

This looks very good popipipo...
But, how would the rows($3:3) look like if you have it in different sheets?
=IFERROR(INDEX($A$3:$A$10;MATCH(ROWS($3:3);$F$3:$F$10;0));"")

I dont get it to work..
Could you please split this into two sheets?
Thank you very much for your help!

Yeah..
IT works now!
Thank you!!