extract Employee ID by matching name and email address

Hello ALL,

I have two sheets-Sheet1 has Last name,First name in one column and email address in one column.
Sheet2 also has Last name, First name in one column, email address in one column and Employee id in another.

I want a macro to match names from sheet 1 with two columns - Last name, First name and also email address if both match than i wanted to extract Employee id and write adjacent to that name on Sheet 1

Thanks
Puneet

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

Sheet 1
Employee_ID Employee Name EMP_Email
Tatiana Ilescu [email protected]
Virginie Cote [email protected]
VIVIAN GARCIA [email protected]
Vanessa Thermogene [email protected]
Sheet 2

EMP_ID EMP_NAME EMP_Email
3156890 Tatiana Ilescu [email protected]
4151000 Virginie Cote [email protected]
3130190 VIVIAN GARCIA [email protected]
3174200 Vanessa Thermogene [email protected]

Both emp_name and Emp_email has to match in order to fill Emp_ID in sheet 1.

Thanks
Puneet

Considering in most cases you only have one email per employee can't you just use formulas in column A of Sheet1 based on the email to do the job like so:

=INDEX(Sheet2!A:A,MATCH(C2,Sheet2!C:C,0))