I've got a huge list of part numbers for multiple projects, so there are many number repeats.

I have a different list of each part type with each cost.

Is there any way to put the cost of any given part from the price list next to each part on my project list?

Any help would be greatly appreciated.