Home

Compare match and move data between 2 workbooks

%3CLINGO-SUB%20id%3D%22lingo-sub-854761%22%20slang%3D%22en-US%22%3ECompare%20match%20and%20move%20data%20between%202%20workbooks%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-854761%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20data%20in%20workbook%20A%20that%20includes%20an%20Old%20ID%20number%20and%20an%20New%20ID%20number%2C%20then%20in%20workbook%20B%20I%20have%20the%20Old%20ID%20number%20and%20name%20which%20is%20a%20subset%20of%20workbook%20A.%26nbsp%3B%20Workbook%20A%20is%20the%20master%20file%20containing%20all%20Old%20ID%20numbers%20ever%20created%20for%20that%20location%20and%20workbook%20B%20is%20only%20those%20that%20are%20currently%20active.%26nbsp%3B%20I%20am%20looking%20for%20a%20way%20to%20move%20the%20New%20ID%20number%20from%20workbook%20A%20to%20its%20match%20in%20workbook%20B.%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3CP%3EWorkbook%20A%20only%20contains%20Old%20ID%20(column%20A)%20and%20New%20ID%20(column%20B)%3C%2FP%3E%3CP%3EWorkbook%20B%20contains%20Old%20ID%20(column%20A)%20and%20Name%20(column%20B)%20(need%20to%20move%20New%20ID%20to%20this%20workbook)%3C%2FP%3E%3CP%3Eattempted%20Vlookup%20but%20keep%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-854761%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-855084%22%20slang%3D%22en-US%22%3ERe%3A%20Compare%20match%20and%20move%20data%20between%202%20workbooks%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-855084%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F408611%22%20target%3D%22_blank%22%3E%40ktwogood253%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIn%20general%20VLOOKUP%20shall%20work.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-855096%22%20slang%3D%22en-US%22%3ERe%3A%20Compare%20match%20and%20move%20data%20between%202%20workbooks%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-855096%22%20slang%3D%22en-US%22%3E%3CP%3EThank%20you%2C%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F521%22%20target%3D%22_blank%22%3E%40Sergei%20Baklan%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20couldn't%20get%20it%20to%20work%20between%20the%20two%20different%20workbooks%20so%20I%20copied%20the%20worksheet%20I%20needed%20into%20the%20other%20workbook%2C%20created%20the%20VLOOKUP%20and%20it%20appears%20to%20be%20working.%26nbsp%3B%20I%20have%20more%20than%202000%20lines%20of%20data%20but%20after%20verifying%20the%20first%2015%20to%2020%20lines%20it%20appears%20to%20be%20accurate.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-855625%22%20slang%3D%22en-US%22%3ERe%3A%20Compare%20match%20and%20move%20data%20between%202%20workbooks%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-855625%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F408611%22%20target%3D%22_blank%22%3E%40ktwogood253%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIs%20it%20possible%20if%20you%20provide%20some%20sample%20to%20check%20what%20exactly%20doesn't%20work%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E
ktwogood253
New Contributor

I have data in workbook A that includes an Old ID number and an New ID number, then in workbook B I have the Old ID number and name which is a subset of workbook A.  Workbook A is the master file containing all Old ID numbers ever created for that location and workbook B is only those that are currently active.  I am looking for a way to move the New ID number from workbook A to its match in workbook B.  

Workbook A only contains Old ID (column A) and New ID (column B)

Workbook B contains Old ID (column A) and Name (column B) (need to move New ID to this workbook)

attempted Vlookup but keep 

3 Replies

Thank you, @Sergei Baklan 

I couldn't get it to work between the two different workbooks so I copied the worksheet I needed into the other workbook, created the VLOOKUP and it appears to be working.  I have more than 2000 lines of data but after verifying the first 15 to 20 lines it appears to be accurate.

@ktwogood253 

Is it possible if you provide some sample to check what exactly doesn't work?

Related Conversations