Tom’s Tutorials For Excel: LOOKUP Column Header of First Non Zero Cell in a Row
Here’s an example of identifying the column, and then the value of the header in row 4 of that column, for the first cell in a row that is not a zero.
In cell N5 and copied down as needed is the array formula
The “+1” in the formula for the
MATCH function is to account for the column number in the array being returned, with column A not a part of the array. So getting the grid’s actual column number along with known header row 4 produces the map to finding that intersecting cell’s month label.
Recall, array formulas are entered by simultaneously pressing the
Ctrl+Shift+Enter keys, not just
Enter. The curly braces are not entered by you. Excel places them automatically when the array formula is properly applied.