Copying text value based on long (comlex) calculation
 

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.


--
gezuvor
------------------------------------------------------------------------
gezuvor's Profile: http://www.excelforum.com/member.php...o&userid=30383
View this thread: http://www.excelforum.com/showthread...hreadid=500451