I have 2 workbooks, WBOOK1 and WBOOK2. Both have column A formatted exactly
the same. WBOOK2.A is a subset of WBOOK1.A. WBOOK2 also has 2 additional
columns not in WBOOK1. I would like to bring WBOOK2.B and WBOOK2.C into
WBOOK1, leaving them blank for rows that are in WBOOK1 but not WBOOK2 and
populating them in WBOOK1 as they are in WBOOK2 for rows that exist in both
WBOOK1 and WBOOK2.

I do not have tracking turned on, so I cant use the Microsoft merge tool (I
guess I could turn it on at the start). Currently what I am doing is
downloading WBOOK1 and WBOOK2 to our mainframe, do a left outer SQL join and
upload the result back to Excel. I essentially want to emulate this process
only doing it all manually in Excel.

OK.....I think I figured out how to do this using VLOOKUP (if there is a
better way, let me know). The only problem is that for every row in WBOOK1
for which WBOOK1.A is less than the lowest value in WBOOK2.A, it places
"N/A". WBOOK1.B. Othere than that, VLOOKUP seems to work. Is there a way to
avoid this?

"GKW in GA" wrote:

I have 2 workbooks, WBOOK1 and WBOOK2. Both have column A formatted exactly
the same. WBOOK2.A is a subset of WBOOK1.A. WBOOK2 also has 2 additional
columns not in WBOOK1. I would like to bring WBOOK2.B and WBOOK2.C into
WBOOK1, leaving them blank for rows that are in WBOOK1 but not WBOOK2 and
populating them in WBOOK1 as they are in WBOOK2 for rows that exist in both
WBOOK1 and WBOOK2.

I do not have tracking turned on, so I cant use the Microsoft merge tool (I
guess I could turn it on at the start). Currently what I am doing is
downloading WBOOK1 and WBOOK2 to our mainframe, do a left outer SQL join and
upload the result back to Excel. I essentially want to emulate this process
only doing it all manually in Excel.