Hello,
Im trying to solve this problem without the use of a helper column!
I know to evaluate using a helper column in which I would add: =INDEX(C1:D1,MIN(C2:D2),C2:D2,0)
2017-05-02 13_51_24-Bid_Comparison_Report.xlsb - Excel.png
I want to be able to return the lowest bidding supplier based on a given material. See the example above: Widget A has was bid by two suppliers. Supplier XYZ is the lowest bidding supplier. I want to be able to put in a formula, whereby I look up the Material and return the supplier in another sheet.
Bookmarks