extract Employee ID by matching name and email address

[PSoni]

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

[xladept]

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

[PSoni]

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

[bakerman2]

Maybe something like this.

Please Login or Register  to view this content.

[PSoni]

Why there are two Next statements, also there is no End if. This macro is not working

[bakerman2]

1.Why should there be an End If if there's no If ?????
2.There are 2 Next statements because there are 2 For statements.
3.Learn the VBA basics before making any unfounded comments.
4.The macro isn't working for you because it's based on an example file I myself created because you failed to provide one yourself, a request already made by xladept a few posts ago !!!

[PSoni]

sorry i was not trying to be rude may be my wording was not right. wanted to understand the code. and yes i am a nubie and do not have much experience in vba. The code when i use gave me error in 6th line. may be because the column's are different in my sheet.

[bakerman2]

That's why we ask to provide an example file which reflects the true situation of your workbook so we can see how to proceed.

[Trebor76]

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))