As an example enter 1 in A1 and 2 in B1, Pen A in A2 and Pen B in B2. Let the
cells A3 to B6 contain data. In cell F3 enter
=SUMPRODUCT($A$1:$B$1,--($A3:$B3=MIN($A3:$B3)))
In cell G3 enter
=HLOOKUP(F3,$A$1:$B$4,2)
Copy cells F3 and G3 down.

"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.