Paste this in Sheet1 AK and drag that to the right columns . and then drag it
down as needed.

=IF(Sheet1!$A2=Sheet2!$A2,Sheet2!A2,"")

If this post helps click Yes
---------------
Jacob Skaria


"Juan" wrote:

I have a workbook1 that i need to match on ID in A2 with ID on A2 of
workbook2.

If the ID matches, i want to return that single row with all columns from
the second workbook to the first workbook. The data should be returned on
cell AK.
I want to compare side by side data for auditing. If you need more
information let me know.