Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
lookup first & last values within row & return column header value | Excel Discussion (Misc queries) | |||
Return column number from column header text | Excel Discussion (Misc queries) | |||
Lookup Value in Range/Array and Return Column Header Value | Excel Discussion (Misc queries) | |||
Lookup Value in Range/Array and Return Column Header Value | Excel Worksheet Functions | |||
Return Column header, if row value is > X | Excel Discussion (Misc queries) |