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.