How To Determine Match from Multiple Cells in One Row

Question

Editable Test Sheet: https://docs.google.com/spreadsheets/d/1zKtE09TB-mAEQFRswity3R1ZGdYe7jq6ZYh_l4P398E/edit?usp=sharing

Although I believe what I'm trying to do is fairly simple, It is difficult for me to even find the correct words to describe what I'm trying to do. I suspect that is why I've been researching all day for an answer and cannot find it.

I need an ARRAYFORMULA that can check for the existence of a given "PARENT ID" in another table, but only if another cell in the same row is not true.

A given PARENT ID from TABLE 2 could appear in TABLE 1 multiple times, sometimes paired with "TRUE" and sometimes not. I only need to know if the PARENT ID from TABLE 1 appears in TABLE 2 along with the value TRUE in the "Done" column next to it. If it appears even once, I want to denote it in TABLE 2.

I am able to do this in various forms, but none of them work with ARRAYFORMULA.

See the shared example sheet above. I would greatly appreciate any help.

Answer 1

Another answer I received on another forum:

=ArrayFormula(IF(COUNTIF(C3:C&B3:B,E3:E),true,))

Credit to Prashanth KV