{=IFERROR(INDEX(Sheet2!$C$2:$C$8,MATCH(1,(A$10=Sheet2!$A$2:$A$8)*(B$10=Sheet2!$B$2:$B$8),0)),"")}

{=IFERROR(INDEX(Sheet2!$C$2:$C$8, SMALL(IF(COUNTIF($A$15, Sheet2!$A$2:$A$8)*COUNTIF($B$15, Sheet2!$B$2:$B$8), ROW(Sheet2!$A$2:$A$8)-MIN(ROW(Sheet2!$A$2:$A$8))+1), ROW(A1)), COLUMN(A1)),"")}