Can anyone tell me how to accomplish the following:

I have two worksheets with 3 columns (Full Name, Display Name, AccountName).
The values in the €œAccountName€� column are the same in both worksheet, but
the values in the other two are different. I need to find a way to search the
two worksheets and when the AccountName in both worksheets match, I would
like to copy the AccountName, Full Name, and Display Name values to a new
worksheet.

Thanks for your assistance!