@ gmarma
I had attached the file for your reference. There are also two simulation. Unfortunately, this formula could only show one vendor name even if there are two vendors with the same low price.
Formula:
=INDEX($E$2:$N$2,MATCH($C4,$E4:$N4,0))
Bookmarks