| 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
60120 60125 61065 61128 61140
411AMERICAN 1502CDW 437 3172FRANKLINS 263 7876STANDARD 286 7889STAPLES 1,640 30385VACO LLC 102,624 I'm trying to do an index/match function from another page in a workbook (pointing to this range of data). I would like to match from a cell on another page to column A....look across the row to the column with a value 0 and return the column header. For example, 7889STAPLES would return the result "61140"; 1502CDW would return "61065"; and so on. Any ideas? |
| 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) | |||
Threaded Mode
