This formula will retrun the cell reference

=CELL("address",INDEX($A$1:$E$20,MIN(IF($A$3:$E$20 =MIN($A$3:$E$20),ROW($A$3:$E$20))),MIN(IF($A$3:$E$ 20=MIN($A$3:$E$20),COLUMN($A$3:$E$20)))))

entered with ctrl + shift & enter

Adapt to fit your tables ranges etc, my formula was based on that the
headers were in row2, numeric data started in 3 so note that the endex part
starts from the first row, that way you don't have to offset the results from
the min part

Regards,

Peo Sjoblom

"Luanne" wrote:

My data are in 19 columns and 600 rows. I need to find the minimum value in
each row. At the top of the columns are descriptions (e.g. Pen A, Pen B...).
I want to see which column ("Pen X") the minimum for that row came from. I
can get the minimum value in the row using min(), but it is the min value I
need, but the column name that has that value. I have searched for two hours
and cannot figure out how to do this! Can anyone help?

Thanks.