Excel compare partial cell contents

I am currently comparing two lists of email address to find matches between the two.

=IF(ISERROR(MATCH(C2,Sheet1!Z:Z, 0)), "No Match", "Match")

My problem is that some emails I want to INCLUDE are eg.g

John.Smith@Email.com
John.Smith-Work@Email.com

How can I do my match lookup to allow for this variance?