I have a row of 100 items, where each has up to 5 prices.

I have a Nested If to find the cheapest, Line one is the header with supplier. A to I is various details of the product.

'{=MIN(IF(ISNUMBER(I2:M2),I2:M2))}

I'd be grateful to extend this for each line to now calculate the name of the supplier (from column I1 to N1) of the cell with the MIN Vlue result.

Many thanks