Excel troubles

Hi guys,

I currently have 2 spreadsheets. Spreadsheet A has x amount of email addresses.

Spreadsheet B has x amount of email addresses including all of the addresses in Spreadsheet A. It also includes personal information about all of the emails.

I need to find all emails in Spreadsheet A in Spreadsheet B including there relevant data. but i cant seem to do it.

Its a simple task but the only way I can get it working is by using the Find feature in spreadsheet B and typing in the email and copying and pasting the relevant cells. This would be fine but there are several thousand emails in Spreadsheet A and many more in Spreadsheet B

Any help would be much appreciated

*******************************************************************************************************************************************************************
Sorry for creating two of the same threads I thought I was editing the title and I created a new thread. please delete this thread
actual thread can be found here http://www.excelforum.com/excel-gene...her-sheet.html
*******************************************************************************************************************************************************************

Kind Regards,
Sam