Amend the Formula

[Geo Jul]

Dear All​

May I kindly request all how to amend the below formula if one of the criteria is missing​

like Cell C16 or Cell D16​

Many Thanks in Advance

=IFERROR(INDEX(C$4:C$11,SMALL(IF(IF(($C$16=$F$2:$AC$2)*($D$16=$F$3:$AC$3),$F$4:$AC$11),ROW($F$4:$AC$11)-MIN(ROW($F$4:$AC$11))+1),ROWS($1:1))),"")​

 

[James006]

Hi,
Whenever you are after AND, you should use *
But if you need OR, then you should use +

 

[kvsrinivasamurthy]

Try

=IFERROR(INDEX(C$4:C$11,SMALL(IF(IF((($C$16=$F$2:$AC$2)+($D$16=$F$3:$AC$3)),$F$4:$AC$11),ROW($F$4:$AC$11)-MIN(ROW($F$4:$AC$11))+1),ROWS($1:1))),"")

 

[Geo Jul]

Hi,
Whenever you are after AND, you should use *
But if you need OR, then you should use +

Thank you for the reply

 

[Geo Jul]

Try

=IFERROR(INDEX(C$4:C$11,SMALL(IF(IF((($C$16=$F$2:$AC$2)+($D$16=$F$3:$AC$3)),$F$4:$AC$11),ROW($F$4:$AC$11)-MIN(ROW($F$4:$AC$11))+1),ROWS($1:1))),"")

Many Thanks for your reply