Hi

I have one sheet that has a list of part numbers (sheet 1)
A
1 123
2 231
3 123


In a different sheet I have prices (sheet 2)
A B
1 123 $20
2 231 $5
3 321 $0.5


How would I automatically search sheet 2 for the matching part number and put the price next to the part in sheet 1


Thanks