TEXTJOIN based on multiple criteria

[ac7]

Hello -

I have 2 worksheets, Orders and Filtered.

Orders:

Filtered:

I am looking for a way to use TEXTJOIN on the Orders worksheet to give me a list of all parts in column B from the Filtered worksheet that also have a "Y" in column C. This is what I would expect to see for the results on the Orders worksheet:

Any suggestions on how to make this work? If TEXTJOIN is not the best way to do this, I am open to anything that works.

 

[Fluff]

How about

=TEXTJOIN(", ",,FILTER(Filtered!B2:B100,(Filtered!A2:A100=A2)*(Filtered!C2:C100=Y)))

 

[ac7]

How about

=TEXTJOIN(", ",,FILTER(Filtered!B2:B100,(Filtered!A2:A100=A2)*(Filtered!C2:C100=Y)))

Thank you for the swift reply. I'm getting a #CALC! error on row 3 (order 158285) on the Orders worksheet.

What is the best way to suppress or fix those errors?

 

[Fluff]

How about

=TEXTJOIN(", ",,FILTER(Filtered!B2:B100,(Filtered!A2:A100=A2)*(Filtered!C2:C100=Y),""))