Forum Discussion
Find lowest price along with that vendor's name
Hello,
On one tab, "BOM BRKDN", I have a materials list with several unique part numbers. On a second tab, "PRICING", is a list of all vendor quotes for all part numbers.
I have a "Best Price" column (that seems to work fine) using the formula "=MIN(IF(E2=PRICING!$C$2:$C$10000,PRICING!$A$2:$A$10000))"
(fyi; column E is unique part numbers on "BOM BRKDN" tab; column C is part number on "PRICING" TAB, column A is the price quoted on "PRICING" tab.
I am trying to find a formula that will reference the best price and the part number to then find and auto-fill the associated vendor name (listed under column B on the "PRICING" tab).
I've tried a variety of lookup formulas without success. Can someone please help?!?!
Thank you
Corey,
replace your data in sheet "BOM BRKDN" with a pivot table based on sheet "PRICING".
"part number" and "vendor" in row area and "price" in values area. Change the aggregation to "Min".
Corey,
replace your data in sheet "BOM BRKDN" with a pivot table based on sheet "PRICING".
"part number" and "vendor" in row area and "price" in values area. Change the aggregation to "Min".
Thank you Detlef!
This will get me where I need to be.
