Sep 13 2019 10:53 AM
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
Sep 13 2019 02:42 PM
In general VLOOKUP shall work.
Sep 13 2019 02:58 PM
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.
Sep 14 2019 06:00 AM
Is it possible if you provide some sample to check what exactly doesn't work?