I think I'm going about this the wrong way.

I've got 3 quotes for suppliers I'm comparing of prices. All of the lists are similar but have slight differences.

I ran a pivot and wanted to compare which supplier has the cheapest part. The pivot works, but I would like an end product that is easier on the eye.

My goal is to have a simple list as an outproduct of the parts in column A, the cheapest manufacturer in column B, and the price from the manufacturer in column C.
Is there a way for a vlookup (or something similar) to go down a list and if there are duplicate part numbers, return the cheaper of the two using something like a min function?

Thank you for taking the time to look at this.