=VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup])Enter the below into cell B2 and extend down. A2 is the lookup value, use dollar sign $ to lock to values on sheet 2, reference column 2 on sheet 2 and enter 0 for text.
=VLOOKUP(A2,Sheet2!A$1:B$7,2,0)Sheet 1
Sheet 2
