Index, Small, Row issue with Multiple Values and need Multiple Results

Hello!

I'm trying to create a spreadsheet dealing with multiple schedules for multiple people in two buildings and I'm running into some issues.

I'm using Excel 2010 and I have two spreadsheets within a single workbook, my first sheet is called "RawData" and my second sheet is called "Filtered".

On my Filtered sheet I have two drop downs lists in cells A9 & B9 that select a day of the week and a building they work in which work as expected. I need to have these two criteria as people report to different buildings on different days.

I've been trying to figure out how to populate data on my Filtered sheet from my RawData sheet via my two drop downs and want to avoid using Vlookup for extensibility reasons (may want to change what the criteria is at some point or need to add a column).

I am currently using named ranges and have tried the following formula's to no avail and I've been using Control + Shift + Enter to complete these:

=INDEX(Agent,MATCH(1,(Day=$A$9)*(Bldg=$B$9),0)+1)

This populates the correct name but duplicates it when dragged down, I can't figure out a way to make this increment by one so switched to using Small instead.

=INDEX(RawData,SMALL(IF(Day=$A$9,IF(Bldg=$B$9,ROW(Day))),ROW(1:1)),3)

This populates names that don't work on Saturday in building A for example, feel like this is close but it's off somehow.

=INDEX(RawData,SMALL(IF(COUNTIF(Day,$A$9)*COUNTIF(Bldg,$B$9),ROW(Day)-ROW(Day)+1),ROW(1:1)),3)

This populates the wrong name and then duplicates it. Way off with this approach.


To paint a picture for those not wanting to download an attachment:
Example of RawData Sheet starting on Row A5:

Day(A5)_______Bldg(B5)_____Agent(C5)
Sunday________A__________Jane Doe
Monday________B__________Jane Doe
Tuesday_______A__________Jane Doe
Wednesday_____A__________Jane Doe
Thursday_______B__________Jane Doe
Monday________B__________Todd Doe
Tuesday________A__________Todd Doe
Wednesday_____A__________Todd Doe
Thursday_______B__________Todd Doe
Friday__________A__________Todd Doe
Saturday_______A__________Britt Doe
Monday_______A__________Britt Doe
Tuesday_______A__________Britt Doe
Wednesday____A__________Britt Doe

Named Ranges for example workbook are: Day for A6 to A56, Bldg for B6 to B56, and Agent for C6 to C56 which all pertain to my RawData Sheet.

On my filtered sheet I select a day such as Saturday from a list in A9 and Select a building such as A from a list in B9 and I want to populate all agents working that meet those two criteria in D9 to D60 for example. If possible I'd also like to know how to add a 3rd or 4th criteria but this can definitely wait.

I'll also attach a sample sheet of what I'm dealing with which also shows the errors I'm receiving.

Thanks in advance and apologies for the impromptu chart, didn't see any chart formatting options