Study Planner ; Sort Multiple Conditions using Index Small

[x0nar]

I wanted to make a study planner for myself.
For that I have created three Excel Sheets namely Schedule, Tool and Status

In "schedule" Sheet I have created a table as below
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD][/TD]
[TD][/TD]
[TD]Slot 1[/TD]
[TD][/TD]
[TD][/TD]
[TD]Slot 2[/TD]
[TD][/TD]
[TD][/TD]
[TD]Slot 3[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Date[/TD]
[TD]Status[/TD]
[TD]Topic[/TD]
[TD]Lookup[/TD]
[TD]Status[/TD]
[TD]Topic[/TD]
[TD]Lookup[/TD]
[TD]Status[/TD]
[TD]Topic[/TD]
[TD]Lookup[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]


This table will be my planning table and I will be inputting the data here every week
Date refers to the date when I'll be studying a topic
Status refers to if the topic was completed (I will be inputting if Complete or Incomplete at the end of the day here)
Topicrefers to the topic I'll be studying
Lookup refers to a unique ID provided to each topic. (I have arranged for that)
Slots : I have divided each day into 3 Slots Morning, Afternoon and Evening ie Slot 1, 2 ,3 and Date, Topic and Lookup are subcolumns for the respective slots.

In the Tool Sheet
In this sheet I would like to know when I have allotted time for each Subject in the Table as below

Lookup Code : (Enter the Lookup code of Topic Here)

[TABLE="class: grid, width: 250"]
<tbody>[TR]
[TD]Date[/TD]
[TD]Slot[/TD]
[TD]Status[/TD]
[/TR]
[TR]
[TD]Formula[/TD]
[TD]Formula[/TD]
[TD]Formula[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]


As seen above I would like to enter formula in each of the column, such that
The excel sheet after looking at the Lookup Code goes to the Schedule Sheet and analyses the list of occurrences matching with the lookup code.
It then serially posts all of the entries in the above table (Date wise)



Eg. If I input in Schedule Sheet as follows

[TABLE="class: grid, width: 750"]
<tbody>[TR]
[TD]Date[/TD]
[TD][/TD]
[TD]Slot 1[/TD]
[TD][/TD]
[TD][/TD]
[TD]Slot 2[/TD]
[TD][/TD]
[TD][/TD]
[TD]Slot 3[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Status[/TD]
[TD]Topic[/TD]
[TD]Lookup[/TD]
[TD]Status[/TD]
[TD]Topic[/TD]
[TD]Lookup[/TD]
[TD]Status[/TD]
[TD]Topic[/TD]
[TD]Lookup[/TD]
[/TR]
[TR]
[TD]01/01/16[/TD]
[TD]Done[/TD]
[TD]Integers[/TD]
[TD]TPM1[/TD]
[TD]Done[/TD]
[TD]Probability[/TD]
[TD]TPM4[/TD]
[TD]Incomplete[/TD]
[TD]Integration[/TD]
[TD]TPM3[/TD]
[/TR]
[TR]
[TD]02/01/2016[/TD]
[TD]Incomplete[/TD]
[TD]Integration[/TD]
[TD]TPM3[/TD]
[TD]Done[/TD]
[TD]Derivatives[/TD]
[TD]TPF2[/TD]
[TD]Incomplete[/TD]
[TD]Energy[/TD]
[TD]TPS1[/TD]
[/TR]
[TR]
[TD]03/01/2016[/TD]
[TD]Done[/TD]
[TD]Energy[/TD]
[TD]TPS1[/TD]
[TD]Done[/TD]
[TD]Integration[/TD]
[TD]TPM3[/TD]
[TD]Done[/TD]
[TD]Gravity[/TD]
[TD]TPS7[/TD]
[/TR]
[TR]
[TD]04/01/2016[/TD]
[TD]Done[/TD]
[TD]Protons[/TD]
[TD]TPS8[/TD]
[TD]Done[/TD]
[TD]Distributions[/TD]
[TD]TPM9[/TD]
[TD]Done[/TD]
[TD]Earth
[/TD]
[TD]TPG3[/TD]
[/TR]
</tbody>[/TABLE]
Desired Solution in Sheet "Tool"

Now If In the Cell of Lookup Value if I enter TPM3 (ie Lookup value for Integration), then it should display results as follows

[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]Date[/TD]
[TD]Slot[/TD]
[TD]Status[/TD]
[/TR]
[TR]
[TD]01/01/2016[/TD]
[TD]3[/TD]
[TD]Incomplete[/TD]
[/TR]
[TR]
[TD]02/01/2016[/TD]
[TD]1[/TD]
[TD]Incomplete[/TD]
[/TR]
[TR]
[TD]03/01/2016[/TD]
[TD]3[/TD]
[TD]Done[/TD]
[/TR]
</tbody>[/TABLE]

Or if I enter TPS1 in the Lookup cell it should display as follows

[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]Date[/TD]
[TD]Slot[/TD]
[TD]Status[/TD]
[/TR]
[TR]
[TD]02/01/2016
[/TD]
[TD]3[/TD]
[TD]Incomplete[/TD]
[/TR]
[TR]
[TD]03/01/2016[/TD]
[TD]1[/TD]
[TD]Done[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

Now if there was just Slot One, it would not be a problem since I would have used the formula given below
However the problem arises due to multiple slots, and I would prefer the results being arranged serially on the basis of dates


FORMULA ENTERED IN DATE COLUMN

=IF($D$2="","",IFERROR(INDEX(Schedule!B$3:B$189,SMALL(IF($D$2=Schedule!$E$3:$E$189,ROW(Schedule!$E$3:$E$189)-2,""),ROWS($B$5:B5))),""))

Where D2: The Lookup value (to be inputted by user) of the Cell for which results will be displayed
B3 : B189 Refers to the range containing dates in the Schedule Sheet
E3 : E189 refers to the range of Lookup Values inputted in Schedule Sheet

However the above formula considers only one slot. Hence I would like to know how to adjust it to collect multiple rows from other slots as well.
Please Help.