Ok lets try and explain what I want to do

I have a worksheet with some publication data in. Column A has the email address in so [email protected] may show up 10 times because he has 10 publications.

In another worksheet (in the same file) I have a key of email addresses and Staff ID numbers. So [email protected] has a staff ID of 2468. What I need to do is replace the email address in the publications worksheet with the Staff ID numbers in the key worksheet.

Any help greatly appreciated??