Paste the below formula to Sheet1 AK2. Drag that to the right upto needed say
AO2. Then select the range AK2:AO2 and drag that to down.

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


"Juan" wrote:

Thanks but that didn't work. It returned only the ID from on the 4th cell
down with the ID. Not the entire row from the second workbook.

Would it be better if i moved the data from workbook 2 toward the bottom of
workbook one to begin on A1745 rather than on a separate workbook? If so,
what formula would work to bring that data up to the right side.

"Jacob Skaria" wrote:

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.