Excel Formula 1

[mlbbud]

I column "B" I have a list of 5 colors. In column "C" I have the percentage of colored t-shirts I have in stock. I would like to put in a cell in column "D" which color is the lowest I have in stock.

Thanks

 

[bluedragon2]

Look at the MIN function

[Blue]Blue[/Blue] [Dragon]

If I wasn't Blue, I would just be a Dragon...

 

[mlbbud]

I did, but that will only gives me the percentage number. I don't know how to correlate that to the color column, so I can display the color.

 

[bluedragon2]

=INDEX(A1:A4,MATCH(MIN(B1:B4),B1:B4,0))

[Blue]Blue[/Blue] [Dragon]

If I wasn't Blue, I would just be a Dragon...

 

[mlbbud]

Thank you, that worked.