Hello,

I have a FILTER function that tries to exclude matched records from a second table. Current formula.


=UNIQUE(FILTER(CHOOSE({1,2},tblCerts[Full Name],tblCerts[Role]),(tblCerts[Adobe Solution]=J3)  * (tblCerts[Active]="1") * NOT(tblCerts[Full Name]=tblNonEmpl[Resource Name])))
The formula above works if there is only 1 record in the lookup table (tblNonEmpl above) but if I add more than one record, the formula returns an #NA error.

Thoughts on how I can solve this?