I am not sure how to even search for what I want to do, so please forgive me if my first post has been discussed and resolved ad naseum in the past...

Here is my situation:
- I have a workbook that contains multiple sheets.
- Each sheet contains auto parts from different suppliers, sorted by part number.
- Some suppliers have parts that overlap with each other and the various sheets are updated as pricing and availabilty of parts change.
- I am using the VLOOKUP and MIN functions to determine which supplier has lowest cost based on a comparison of part numbers and price across each supplier.
- The first sheet is a summary and contains all of the part numbers (entered manually), as well as the lowest cost from any supplier's worksheet (as calculated above).
- Cell A1 of each supplier sheet has the company name in it.

My question is this:
- For each part number listed on the summary page, I want to display the name of the supplier who has the lowest cost for the item in question.