Looking at other posts, I keeping thinking I'm coming close to a
solution but can't seem to figure it out.

I have a range of values, say: A2:J2
and
I have corresponding text labels for these values: A1:J1

I want to identify the smallest value ( MIN(A2:J2) ) and populate
another cell (say A4) with the corresponding text label that identifies
the smallest value (i.e. if MIN(A2:J2) is the value in cell E2, then I
want cell A4 to contain the text value of E1)

I’m sure I’ve circled around the solution a few times, any help will be
appreciated.

Thanks,
--Robert--


--
WeatherGuy
------------------------------------------------------------------------
WeatherGuy's Profile: http://www.excelforum.com/member.php...fo&userid=9254
View this thread: http://www.excelforum.com/showthread...hreadid=506628