See formula below

Brandon03

If production is found anywhere in in range 2 and OK 3 is not found in range 1 return the data in Range 3 =COUNTIFS({PDCA Range 2}, HAS(@cell, "Production"), {PDCA Range 1}, FIND(NOT({PDCA Range 1} = "OK 3"), @cell) = {PDCA Range 3})

Paul Newcome

Try this...

=JOIN(COLLECT({PDCA Range 3}, {PDCA Range 2}, CONTAINS("Production", @cell), {PDCA Range 1}, NOT(CONTAINS("OK 3", @cell))), ", ")

Paul Newcome

Try this...

=JOIN(COLLECT({PDCA Range 3}, {PDCA Range 2}, CONTAINS("Production", @cell), {PDCA Range 1}, NOT(CONTAINS("OK 3", @cell))), ", ")