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)
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.