G
gezuvor
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.
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.