Compare match and move data between 2 workbooks

[ktwogood253]

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 

[#2]

@ktwogood253 

In general VLOOKUP shall work.

[#3]

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.

[#4]

@ktwogood253 

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