something like this:

=VLOOKUP(A1,Sheet1!$A$1:$B$3,2,0)

change A1 to the location of the first cell of data in what you have listed as "Column 1" on Sheet2.

change A$1:$B$3 to the location of your table of data on Sheet1.

copy down.