# Nested IF, MAX and VLOOKUP question!

#### singe

##### New Member
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

### Excel Facts

Workdays for a market open Mon, Wed, Friday?
Yes! Use "0101011" for the weekend argument in NETWORKDAYS.INTL or WORKDAY.INTL. The 7 digits start on Monday. 1 means it is a weekend.
Hi.

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

Regards

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))

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

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

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

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

Replies
6
Views
145
Replies
16
Views
308
Replies
2
Views
344
Replies
0
Views
200
Replies
4
Views
391

1,203,115
Messages
6,053,590
Members
444,674
Latest member
DWriter9

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

### Which adblocker are you using?

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

### Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back