help with formula


I'm still quite new with sheets and I wonder someone can help me out with this formula I'm currently struggling with.

What I want to do is to check/compare email addresses.

The following works well when adding formula to a check-box type cell comparing whether the [Modified by] entry is the same like [Email] entry. If it's the same, the check-box is ticked.

=IF([Modified by]@row <> Email@row, 1)

Is it possible at all for me to compare the [Modified by] entry against multiple Email addresses (i.e. ranges) rather than against one email address? Perhaps using INDEX or MATCH? If so, how?

Thank you. 


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!