I have 2 spreadsheets with different data but they both have a column for
email address. I need to compare the email addresses in both spreadsheets and
when a match is found, copy and paste the data from columns A,B & C in
spreadsheet 1 into columns X,Y & Z in spreadsheet 2.
End result should be a complete row of data in one spreadsheet only.
Is this possible in Excel?

Thanks in advance!