Finding Min Value based on Value in another cell

**veejar** · 03-15-2012, 01:50 AM

Hello Everyone,

I have a supplier cost for different types of items and for each item there are multiple suppliers for an item. what I want is the minimum cost for the item. I have attached a sample workbook for reference

Regards,

Veejar

**dilipandey** · 03-15-2012, 02:02 AM

Hi Veejar,

Minimum cost per supplier is what I have tried formulating in the attached spreadsheet. Thanks.

Regards,
DILIPandey

<click on below 'star' if this helps>

**vlady** · 03-15-2012, 02:18 AM

can you also try this one.. pls.

=MIN(IF(($B$2:$B$25=B2)*($D$2:$D$25=D2),$F$2:$F$25)) array formula

and look @ gearbox F

**veejar** · 03-15-2012, 02:35 AM

Hi,

Neither of them seems to be working
For an item say Motors_partA the minimum value will always be 1000 according to given data

**vlady** · 03-15-2012, 03:10 AM

sample file

Sample Workbook(2).xls

**veejar** · 03-15-2012, 03:22 AM

Thanks for the solution

**dilipandey** · 03-15-2012, 05:16 AM

Hi Veejar..

I had also saw that the minimum values have to be 1000 according to given data which you have already achieved using your formula and hence thought you might be looking for some other criteria and solution.

Regards,
DILIPandey

<click on below 'star' if this helps>