Cell B2: =IFERROR(VLOOKUP($A2,Sheet2!$A:$B,2,FALSE),"")

and copy down.


Regards