How do I attach the corresponding vendor name (column header) to a MIN
function value when comparing data in the same row horizontally from left to
right? I am trying to find the minimum price for 300 identical item
names(rows) from bids entered by 25 different vendors (columns). I am trying
to show the corresponding vendor name next to the minimum price.

My spreadsheet structu
Item Name, Vendor 1 Price, Vendor 2 Price,..., Vendor 25 Price
Item 1, 0.10, 0.25,..., 0.07
....
Item 300, 0.99, 0.76,..., 0.85

Desired Result:
Item Name, Min Price, Min Vendor Name
Item 1, 0.07, Vendor 25
....
Item 300, 0.73, Vendor 2

Appreciate any info. Thanks.