In sheet 1, I have a long list of part numbers in column A.

In sheet 2, I have two columns with an even longer list of part numbers in column A, and the part name in adjacent column B.

I want to check to see if the part number is listed in both sheets, and if it is, take the part name from sheet 2 and place it in the cell in sheet 1... any suggestions?