Hi Guys,

Would greatly appreciate any input you could give on this.
So I have an excel sheet with two tabs.
The first is a list of all activities, ("TRACKER" TAB) and the column beside it is a date associated with the day the activity is due.
The second is a calendar ("CALENDAR" TAB) format, simply listing each date of the year, and an empty column underneath it.

In the empty column I am inserting the following function: [=INDEX(Tracker!$E$1:$V$41,SMALL(IF(Tracker!$E$1:$V$41=Calendar!E6,ROW(Tracker!$E$1:$V$41)),ROW(1:1)),2)]

What I am trying to achieve, is to use the date in the calendar tab - and search in the array of the tracker tab, returning any activity that corresponds with the respective date. In summary, if you looked at the 8th October on the calendar tab, it would pull all activities associated with that date into the blank cell below it.
I couldnt use a vlookup, as there may be multiple activities with the same date and thus I need to return multiple results.

The formula recognizes the date in the array, and pulls the respective information from the array/activity tab ok, the problem is its the wrong data pulled (same activity returned every time). If the date from the calendar is listed in the activity tab, it will always pull the data in the second column of the array(see last arguement in formula above), what it should do is pull the second column from the array, respective of where the target date lies. So basically cell E6 is the second column, and it returns E6 contents everytime, even if the date is somewhere completely different in the TRACKER tab.

Is there a way I can make this dynamic, so that it pulls the second column respective of the date, as opposed to the second column in general array.

Thanks!!!
Marcus