Try as I may I cant get this to work. I have two workbooks. I'm wanting to return the values as below. I cant see what im doing wrong.

Workbook1 | Column A = ID Numbers
Workbook1 | Column D = Location of formula

Workbook2 | Column A = ID Numbers
Workbook2 | Column B = Value to be returned into WB1 Column D.


Any help appreciated!