2 condition formula

[StellaArtois]

Hello,

could i please ask for a bit of guidance

i have teh following formula that index a search based on criteria in Z2 and AA2
thing is it only returns what is in Z2

think it may be the + inbetween the formula

=IFERROR(INDEX($C$5:$C$4004,SMALL(IF((($F$5:$F$4004=$Z$2)+($M$5:$M$4004=$AA$2)),ROW($C$5:$C$4004)-ROW($C$5)+1),ROWS($4:4))),"")

Any help appreciated thanks

 

[JEC]

how about this one, it gives results when either the first condition is true OR the second one. In your question you talk about "AND". In that case you need "*" instead of "+"

=FILTER(C5:C4004,(F5:F4004=Z2)+(M5:M4004=AA2))

 

[StellaArtois]

Thanks for the quick reply

It returns #SPILL ?

the * solves the issue

Thanks again!

 

[JEC]

You have to clear all data below that formula, it gives you one array of output. Give it a try