=VLOOKUP(A2,Sheet2!$A$2:$B$244,2,0)

in your previous formula a2 was relative