Ok, I am pretty good with Excel but this one has me stumped.

Sheet 1 is a top 100 products. It has a column for the part number.

Sheet 2 has the same part number in a different order and a column for the price.

How do I add the column on sheet 1 to match price and part number by referencing sheet 2