Excel query

Hello,

I want to know how to copy a data from cell of one workbook to cell of another workbook which has same data in different cell?

For example

Work book one

Col A B C D
1 ID Name
2 5 sam
3 6 ram
4


Work book 2
Col A B C D
1 Name
2 ram
3 sam
4 jam


Now to be more specific which formula to use to directly paste information of id in workbook 2 from workbook 1 of respective name.

Thanks

Sam