I have four criteria. When I use Text join with all four criteria, I get no matches; however, when I do it separately, I get matches for all four and common values across all four results. I need a list with just these common values. This is “AND()” logic.

Here is what doesn’t work:

=TEXTJOIN(", ",TRUE,IF((C2>='ACSR DATA'!AC4:AC80)*(C3<='ACSR DATA'!AD4:AD80)*(C3>='ACSR DATA'!AE4:AE80)*(C4>='ACSR DATA'!AF4:AF80),'ACSR DATA'!B4:B80,""))

Here is what works:

=TEXTJOIN(", ",TRUE,IF(C2>='ACSR DATA'!AC4:AC80,'ACSR DATA'!B4:B80,""))
=TEXTJOIN(", ",TRUE,IF(C3<='ACSR DATA'!AD4:AD80,'ACSR DATA'!B4:B80,""))
=TEXTJOIN(", ",TRUE,IF(C3>='ACSR DATA'!AE4:AE80,'ACSR DATA'!B4:B80,""))
=TEXTJOIN(", ",TRUE,IF(C4>='ACSR DATA'!AF4:AF80,'ACSR DATA'!B4:B80,""))

Goal: Output of comma delimited list based on multiple criteria.

I have tried crtl+shft+entr, TEXTSPLIT(), VSTACK(), UNIQUE(), and FILTER() in various combinations with no luck.