Want to fetch some data from an excel sheet to another using VLookup and macro -

workbook 1 workbook 2

id value
1 a
2 b

id value
1
2

so want fetch b value workbook 1 using value 2 , put in workbook 2 along side 2.

thanks in advance

below formula. work if both workbook opened in same instance.

=vlookup(a2,[book1]sheet1!a$1:b$3,2,0) 

if multiple instance of excel running task manager show more 1 image name excel.exe in task manager processes window.