So some agency want to know how many users are allowed to get into their system they send me all users that are allowed, now i want match every user with their data, if the user exit in their column then write "TRUE" if not "FALSE"? Thank you.
| Names | Agency1 | Allowed? |
|---|---|---|
| user565 | user44 | FALSE |
| user4851 | user4 | TRUE |
| user548 | user3 | FALSE |
| user4 | user884 | FALSE |
CodePudding user response：
You should be able to accomplish this using 
CodePudding user response：
Another alternative is to use COUNTIF.
=ArrayFormula(countif(A2:A5,B2:B5)>0)
