Nested IF, MAX and VLOOKUP question!

[singe]

Hi,
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

 

[XOR LX]

Hi.

What if more than one supplier share the minimum value? Do you have a preference as to which should be returned?

Regards

 

[steve the fish]

Something like this, where R2 is the cell with the result of the MIN calculation.

=INDEX($I$1:$M$1,MATCH(R2,I2:M2,0))

 

[singe]

Hi.

What if more than one supplier share the minimum value? Do you have a preference as to which should be returned?

Regards

Its a good point.
They generally won't but if it could just highlight I would look at the existing supplier a few rows on.
Thanks very much

 

[XOR LX]

Its a good point.
They generally won't but if it could just highlight I would look at the existing supplier a few rows on.
Thanks very much

Sorry - highlight what? Is this formula actually to be incorporated into some sort of Conditional Formatting, then?

Regards

 

[singe]

Something like this, where R2 is the cell with the result of the MIN calculation.

=INDEX($I$1:$M$1,MATCH(R2,I2:M2,0))

Thank Thank you, minor adjustment, where the MIN result is in column Z, but perfect for me.
It saved me a lot of work, so thanks once again

 

[singe]

Sorry - highlight what? Is this formula actually to be incorporated into some sort of Conditional Formatting, then?

Regards

If it could just somehow say is more than one answer.
Its not Conditional Formatted.
Thanks