Maybe it was just line wrap.

Try adding a space, then underscore after that top line:

If Not IsError(Application.Match(.Cells(i, "C").Value, _
sh2.Range("C:C"), 0)) Then

(Or put it all on one line)

Ed wrote:

Hi Bob - THANKS a bunch for your help... However, I get the following error
when running the macro:

If Not IsError(Application.Match(.Cells(i, "C").Value,
sh2.Range("C:C"), 0)) Then

Does this make sense?

Thanks!

"Ed" wrote:

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!




--

Dave Peterson