Use cannot use logical functions (AND, OR, NOT) within an array formula
But AND can be replaced by multiplication and OR by addition
Example IF(AND(A10, B11).... is the same as IF((A10)*( B11).... because
you will get either 1 (TRUE) or 0 (FALSE)

So I would expect this to work:
{=INDEX($B$1:$B$10,SMALL(IF(($A$1:$A$10=$F$3)*(($C $1:$C$10=$E$3),ROW($B$1:$B$10)),1))}best wsihes--Bernard V LiengmeMicrosoft Excel MVPhttp://people.stfx.ca/bliengmeremove caps from email"Rakesh Gupta" wrote in ... 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