Hey All,

I am trying to pull all values from a dataset using multiple conditions. I have narrowed this down to two formulae, but I cannot figure out how to combine the two. The first formula can pull every result of data based on a single condition, while the second formula can only pull the first result of the data based on multiple conditions. I hope I've explained this thoroughly enough. Here is a copy of the formulae and an attached sample workbook.

Every result, one criteria:
{=IF(ISERROR(INDEX($A$1:$B$14,SMALL(IF($A$1:$A$14=$F$2,ROW($A$1:$A$14)),ROW(1:1)),2)),"",INDEX($A$1:$B$14,SMALL(IF($A$1:$A$14=$F$2,ROW($A$1:$A$14)),ROW(1:1)),2))}

First instance, multiple criteria:
{=INDEX($B:$B,MATCH(1,($F$2=$A:$A)*(10=$C:$C)*(2011=$D:$D),0))}

Thank you, this place is a godsend lol.

sample data.xlsx