If headings QS, SF, and
PR are in cells D1:F1
with their data below them...
This formula finds the heading for the lowest
value in D5:F5
=INDEX($D$1:$F$1,MATCH(MIN(D5:F5),D5:F5,0))
Is that something you can work with?
Regards,
Ron Coderre
Microsoft MVP (Excel)
"Tessa" wrote in message
...
I want to search for the minimum value in each row and then return the
column
header for the answer. For example:
FROM zip city QS SF PR
55001 AFTON 17.5 29.08 10.5 "answer"
Where the answer would be PR
I need this formula to copy down 178 rows as well. I have tried lookup,
hlookup and a few others, but cant seem to get it to work. Thanks in
advance.