I am using the below formula and it is working fine.

{=INDEX($B$1:$B$10,SMALL(IF($A$1:$A$10=$F$3,ROW($B $1:$B$10)),1))}

Now I want to check two conditions in this array formula.

for e.g.
IF($A$1:$A$10=$F$3
and
IF($C$1:$C$10=$E$3

Please Help