If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
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. |
#3
|
|||
|
|||
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. |
#4
|
|||
|
|||
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. |
Thread Tools | |
Display Modes | |
|
|