Select multiple criteria and return multiple results

Hi guys

I'm looking for some help with a multiple criteria search function. My database is arranged as follows:

Sheet 1
Column A - list of names
Row 1 - Days of the week
For each name and day there is a time slot entered (AM, PM, All day) that indicates each individuals availability for each day of the week.

Sheet 2
Cell A2 - Drop down of days of the week
Cell B2 - drop down for time slots

What I want to be able to do is select a day of the week in cell A2 and a time slot in cell B2 and it return all available names in column C that match the criteria.

I've attached a sample database to illustrate my request. If there is a VBA option for this that would be great as well.

As always any help you can offer is greatly appreciated.

Regards

Mac

write at sheet2 C2 array formula
{=IFERROR(INDEX(Sheet1!$A$2:$A$4;SMALL(IF(Sheet1!$B$1:$F$1&Sheet1!$B$2:$F$4=$A$2&$B$2;ROW($B$2:$F$4)-1);ROW(1:1)));"")}

copy down

Hi guys

Thank you. Worked perfectly

Regards

Mac