## Wednesday, October 10, 2012

Question:

I have a row listing prices of items from various stores, using the MIN function I am able to find the lowest value, however, how can I tell what Column that came from so that I may return which store returned the lowest value?

Solution:

In the above spreadsheet you can see the products are listed along with there prices row-wise, so we are having Column A with product name and then Column B to Column F are having prices from various brands.

So now to get the minimum price we can use function =MIN(B2:F2), which will give us the minimum price from range B2:F2.

So now to get the Brand name from the column header that has the lowest price listed, you can have the following formula:

Use the following formula in Cell G2:
=INDEX(\$B\$1:\$F\$1;1;MATCH(MIN(B2:F2);B2:F2;0))

and to avoid the blank columns or any error use the following formula:
=IFERROR(INDEX(\$C\$1:\$F\$1;1;MATCH(MIN(C2:F2);C2:F2;0));"")

and then drag it down as far as needed.

I hope the above solution will help you, and if you need more help then please do comment below on this blog itself, I will try to help you out.

I also take up private or confidential projects:

If this blog post was helpful to you, and if you think you want to help me too and make my this blog survive then please donate here: http://igoogledrive.blogspot.com/2012/09/donate.html

Thanks,
Kishan,