google sheets – Test if text in a range of cells exists on a single cell

Use textjoin() to build a regular expression and use it to test the email addresses, like this:

=arrayformula( 
  ifs( 
    isblank(A2:A), iferror(1/0), 
    regexmatch( A2:A, textjoin("|", true, Bad!B2:B) ), "Bad", 
    true, "Good" 
  ) 
)

To learn the exact regular expression syntax used by Google Sheets, see RE2.