This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
Multi-field formula is not required in @rarmstrong's example -- the regular Formula tool should work.
The Contains syntax is fine for your example data, but I'd be a bit careful if the examples are just for illustration -- a Contains query looks anywhere in the string, so Tester "Al" would match with Reviewers Alan, Alfred, and Alice.
I'd be tempted to modify the formula to:
Then 1 Else 0 Endif
If you needed something more dynamic, where the list of fields was changing or was fairly extensive, I think you could work with Transposing the data using a Group By on your [Tester] field and then using some Formulas.