Get cell in the same column as the minimum number in row

[Lustig]

Heya!

I have some troubles finding a function for this. I have a large matrix of numbers representing the cost of different quantities in the columns and products in the rows. I want to minimize the costs and get the quantity connected to that value, i.e. first entry in the same column.

I thought I would be able to use something like =column(min(array)).
But that doesn't seem to work.
Any ideas?

[Haseeb Avarakkan]

Hello Lustig,

Welcome to the forum!

If you can attach a dummy file with the desired result, it would be help.

Anyway, assume A2 to down starts the products.
B1:H1 is Quantity columns, So use this in I2 & copy down.

=INDEX(B$1:H$1,MATCH(MIN(B2:H2),B2:H2,0))

[Lustig]

Hello Lustig,

Welcome to the forum!

If you can attach a dummy file with the desired result, it would be help.

Anyway, assume A2 to down starts the products.
B1:H1 is Quantity columns, So use this in I2 & copy down.

=INDEX(B$1:H$1,MATCH(MIN(B2:H2),B2:H2,0))

Thank you! This worked perfectly