Matching up multiple part numbers with single price

Hello,

Hope someone can advise on this as excel certainly isnt my Forte.

Basically I have a list of part numbers which need pairing up to a price list.

For example, I have multiple of the same part number on one list, and just the single part number and price on another list.

Is there a way to pull the price which corresponds with the single part number, into the multiple part number list in a seperate column? Not sure if ive made sense but will give an example...

sheet 1
A(part number) B(price)
KO1500 - blank
KO1500 - blank
KO1500 - blank
KO1500 - blank
KO1520 - blank
KO1520 - blank
KO1520 - blank
KO1520 - blank
KO1520 - blank

sheet 2
A(part number) B(price)
KO1500 - 45.95
KO1520 - 49.95

Is there a way to pull the price information from sheet 2 into sheet one so it matches all of the same part numbers with the price from sheet 2?

Or perhaps its easier to copy the multiple part numbers from sheet one to say column C on sheet 2 and then use D to match up the prices, so everything is on the one sheet to do the macro.

Any thoughts would be greatly appreciated
Thank you
Sam