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.
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?
Help Article Resources
Check out the Formula Handbook template!