Return Rows from another workbook

J

Juan

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.
 
J

Jacob Skaria

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
 
J

Juan

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.
 
J

Jacob Skaria

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
 
J

Juan

I know what's wrong. Both sets of data are not aligned and one side may be
missing records. There is about 100 record discrepancy and that's why IDs do
not align in the exact row.

Can something be done to do a search on the ID column no matter the position
and return that row anywhere. I already sorted the IDs smallest to largest.
 
J

Jacob Skaria

Dear Juan

Try using VLOOKUP in Sheet1.

Sheet1 AK2 = Vlookup($A2,Sheet2!$A:$A,2,FALSE)
Sheet1 AL2 = Vlookup($A2,Sheet2!$A:$A,3,FALSE)
Copy this to AO2.

Sheet1 AK3 = Vlookup($A3,Sheet2!$A:$A,2,FALSE)
Sheet1 AL3 = Vlookup($A3,Sheet2!$A:$A,3,FALSE)


If this post helps click Yes
 
J

Juan

No it didn't work. Maybe my data is not aligned enough to return all match
and return all rows.

Thanks anyway.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

STOP close button on another workbook 6
Stop Command Question 4
Continue macro from current workbook 0
Workbook Variables 2
Transfer data from one workbook to another workbook based on a key 2
Auto populate value from one task to another in MS PROJECT 0
To copy Data from a row in one wrokbook and insert in a sheet of another workbook 0
copy range using last active cell reference from 1 wkb to another 1

Top