| 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. |
| 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) | |||
Threaded Mode
