I usually use =VLOOKUP(J2,Sheet2!$B$1:$C$703,2,FALSE) (false for exact matches) but I think Hemesh's observation is exactly what is missing, I added false and it appears to be returning the values you want.