Excel: Matching email values in 2 columns

What is the formula for matching values in two columns. the email address matching data should be listed in column C and D, please see attached excel file.   - Target email not in actual email - a...