I've got my column headers as dates Column C:N and my rows 2-3 contain the numbers. I'd like to find the cell in row 2 that first reached a number >=1 and return the date in column header.
I'd like to have Column T return the column header for the cell that first meets my criteria.
My formula is =IFERROR(LOOKUP(2,1/(c2:S2>1),C1:S1),"")
but it returns the last column header for the cell that last met the criteria and not the first cell meeting my criteria.
T2 should return 5/1/21 and T3 should return 9/1/21
What am I doing wrong?
I'd like to have Column T return the column header for the cell that first meets my criteria.
My formula is =IFERROR(LOOKUP(2,1/(c2:S2>1),C1:S1),"")
but it returns the last column header for the cell that last met the criteria and not the first cell meeting my criteria.
T2 should return 5/1/21 and T3 should return 9/1/21
What am I doing wrong?