HOW COMBINE CELLS AND FORMULAS?

Hello, gurus! I need help understanding how to replace / substitute data into a working formula. (Excel workbook attached)

Working formula:

=IFERROR(TEXTJOIN(", ",TRUE,IF((Table_JobOrders[2DigZip]=INDEX(CandTable[2DigZip],MATCH(CandTable[candidateID],0)))*(Table_JobOrders[Results3]=INDEX(CandTable[Results3],MATCH(CandTable[candidateID],0))),Table_JobOrders[jobOrderID],"")),"")

Formula with Substitutions / Replacements: (reference my Excel example)

=IFERROR(TEXTJOIN(", ",TRUE,IF($C$24=1,$D$24,"") &"" & IF($C$25=1,$D$25,"")&"" & IF($C$26=1,$D$26,"")&"" & IF($C$27=1,$D$27,"")&"" & IF($C$28=1,$D$28,""),Table_JobOrders[jobOrderID],""),"")

The working formula returns a list of matching job orders; the other formula returns the "meat" of the formula, but I can't figure out how to make the formula "run." 

I want the end result to be this: in cells C24: C28, the 0 or 1 will determine if the data in the corresponding cells (D24: D28) will be used in the formula.

Thanks!

Ronna