Return Rows from another workbook
 

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.

Return Rows from another workbook
 

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.

Return Rows from another workbook
 

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.

Return Rows from another workbook
 

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.

Return Rows from another workbook
 

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.

"Jacob Skaria" wrote:

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.

Return Rows from another workbook
 

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
---------------
Jacob Skaria


"Juan" wrote:

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.

"Jacob Skaria" wrote:

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.

Return Rows from another workbook
 

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

Thanks anyway.

"Jacob Skaria" wrote:

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
---------------
Jacob Skaria


"Juan" wrote:

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.

"Jacob Skaria" wrote:

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.

Return Rows from another workbook
 

May be you can try out with small amount of data in a different sheet; and
once you are comfortable ...can try out in this sheet

Refer this link...
http://www.timeatlas.com/mos/5_Minut...OKUP_in_Excel/

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


"Juan" wrote:

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

Thanks anyway.

"Jacob Skaria" wrote:

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
---------------
Jacob Skaria


"Juan" wrote:

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.

"Jacob Skaria" wrote:

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.