| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to return column header contents when a cell in the column has a value
Hi,
Am Tue, 4 Aug 2015 20:10:02 -0700 (PDT) schrieb : For example, 7889STAPLES would return the result "61140"; 1502CDW would return "61065"; and so on. try: =INDEX($1:$1,MATCH(1,ISNUMBER(INDIRECT(MATCH("7876 STANDARD",$A$1:$A$100,0)&":"&MATCH("7876STANDARD", $A$1:$A$100,0)))*1,0)) or =INDEX($1:$1,MATCH(1,ISNUMBER(INDIRECT(MATCH(A5,$A $1:$A$100,0)&":"&MATCH(A5,$A$1:$A$100,0)))*1,0)) and enter these formulas with CTRL+Shift+Enter Regards Claus B. -- Vista Ultimate / Windows7 Office 2007 Ultimate / 2010 Professional |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Return column header | Excel Discussion (Misc queries) | |||
| How to return a Column Header | Excel Discussion (Misc queries) | |||
| Return header cell of last column with data | Excel Discussion (Misc queries) | |||
| Return column number from column header text | Excel Discussion (Misc queries) | |||
| Return Column header, if row value is > X | Excel Discussion (Misc queries) | |||
Hybrid Mode
