In Sheet 1 I have a list of emails and I would like to add a status (either Good or Bad / true or false) next to it if the email contains any of the substrings in the Sheet 2.
Sheet 2 has a list of substrings that constitute a "bad email" such as @test.com
or noreply
that are in a list of cells.
I've searched around and cannot find similar questions so I think this would be helpful for those searching for the same problem in the future.