Compare 2 columns to a 3rd column function needed

I need a function that does the following: (SEE ATTACHED SAMPLE WORKBOOK)

Sheet 1'Email' Column A(A2:A1000) Column B(B2:B1000) compared to Sheet 2 Column C(C2:C1000) Column D (text value added; value will be either Match or No Match)


Sheet 1 is named Email, Sheet 2 doesn't have a name

Sheet 1 'email' columns searched
In the Sheet 1'email' sheet, there is Column A that has email addresses in each cell (one email address in each cell)
In the Sheet 1'email' sheet, there is Column B that has email addresses in each cell (one email address in each cell)

Sheet 2 column searched
In the Sheet 2 sheet, there is Column C that has email addresses in each cell (one email address in each cell)
Sheet 2 text value added
Column D has a text value of either Match or No Match

I need to compare the email address that is in Sheet 2 Column C cells C2 to C1000 to both the Sheet 1'email' Columns A and B
and see if the email address that is in Sheet 2 C2 is ANYWHERE in either Sheet1'email' Column A A2:A1000 and/or Column B B2:B1000

If the email address in Sheet 2 Column C cell C2 is found in either Sheet 1'email' Column A cells A2:A1000 and/or Sheet 1'email' Column B cells B2:B1000,
I want to put the value Match in the blank cell D2 in Column D of Sheet 2. If there is not a match found, then the value No Match will go in Sheet 2
Column D cell D2. This will be the pattern to check all values in Sheet 2 Column C: if a match from Sheet1'email' Column A and/or Column B is found for
Sheet 2 Column C cells C2:C1000, then put the text value Match or No match in Sheet 2 Column D cells D2:D1000.

I know that I am probably being too **** with my explanation. I just wanted to make sure that you know what I'm saying and what I want the function to do.

Thank you very much,
Jason