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

@ktwogood253 

In general VLOOKUP shall work.

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
Tabs and Dark Mode
cjc2112 in Discussions on
38 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies