Hi,

Does this do what you want?

=INDEX($B$1:$B$10,MATCH(1,($A$1:$A$10=$F$3)*($C$1: $C$10=$E$3),0))

Mike

"Rakesh Gupta" wrote:

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