I came across another issue regarding this formula.
When the field is empty, it shows the name of that empty field. Sometimes I don’t want to put any values for a certain vendor for the item. Is it somehow possible to exclude empty fields in the formula?
Also notice that when I have two (or more) empty fields, it doesn’t show any information at all.
In case I have two vendors with the same price, it would be perfect if it can show me the name of both vendors in that field. However, I can imagine that this is technically hard (or even impossible).
Is it possible to fix this?
IF(AND(Vendor1 < Vendor2, Vendor1 < Vendor3, Vendor1 < Vendor4, Vendor1 < Vendor5),"Vendor1",IF(AND(Vendor2 < Vendor1, Vendor2 < Vendor3, Vendor2 < Vendor4, Vendor2 < Vendor5),"Vendor2",IF(AND(Vendor3 < Vendor1, Vendor3 < Vendor2, Vendor3 < Vendor4, Vendor3 < Vendor5),"Vendor3",IF(AND(Vendor4 < Vendor1, Vendor4 < Vendor2, Vendor4 < Vendor3, Vendor4 < Vendor5),"Vendor4",IF(AND(Vendor5 < Vendor1, Vendor5 < Vendor2, Vendor5 < Vendor3, Vendor5 < Vendor4),"Vendor5",BLANK())))))