Multiple Criteria with TextJoin

[AlexKimball81]

Hi all,
I was wondering if anyone knows if you can use IfAnd statement within a TExtjoin to set multiple criteria. I have been able to use If statements but i am unable to get a ifand Statement to work.

{=TEXTJOIN(CHAR(10),1,IF(AND(B4:B15=F16,H4:H14=D17),K4:K14,""))}

 

[Mike Blackman]

Hi Alex,

It appears the AND isn't processing as an array, try this:

=TEXTJOIN(CHAR(10),1,IF((B4:B15=F16)*(H4:H15=D17),K4:K15,""))

Again confirmed with Control, Shift & Enter.

 

[AlexKimball81]

Thanks, that worked for 2 criteria. If i was going to add in a third criteria would i have to do anything different?