Hey,
I got an issue where I need to select largest quantity supplier based on best price, when the price is equal
I was able to get the supplier with lowest price with the formula:
=INDEX(B1:F1;MATCH(MIN(B2:F2);B2:F2;0))
but I can't figure out how to get the lowest quantity when there are multiple min values
sup.png
I can also get the supplier price with
=INDEX(B2:F2;MATCH(B6;B1:F1;0))
Bookmarks