Hi,

Assuming your data in Sheet1 start in A2 then use this formula in F2:

=IFERROR(VLOOKUP(A2;Sheet2!A2:A2000;2;0);"")

depending of your regional setting change ";" with "," in that formula.

IFERROR is for excel version >=2007