Column Title Lookup

Hi All,

I have been assigned a task of finding the lowest cost of four possible solutions however I have quite an extensive list of items to work with.

To make this easier, I need to be able to find the lowest cost in my row (which is not sorted by lowest to highest value) and return the column heading associated with that lowest cost.

I have included a sample for analysis purposes.

Thanks.

CF

creativefusion,

The formula in cell F2, copied down:
=INDEX($A$1:$E$1,1,MATCH(MIN($A2:$E2),$A2:$E2,0))