Return column header as solution to lookup
 

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.

Return column header as solution to lookup
 

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.

Return column header as solution to lookup
 

If the header is in row 1, put this in G2:
=INDEX($1:$1,MATCH(MIN(A2:F2),A2:F2,0))
and fill down
Bob Umlas
Excel MVP

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

Return column header as solution to lookup
 

This worked perfectly! THANK YOU!!

"Ron Coderre" wrote:

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.