Formula lookup

[Dastnai]

Hi Everyone,

I am looking for a formula to bring back the column header for the first value in a cell. Here is an example:

Customer	12/17/2018	12/18/2018	12/19/2018	12/20/2018	12/21/2018
Customer A		800	800	800	515

<tbody>
</tbody>

My goal is to bring back 12/18 since it is the first cell with a value.

Thanks for your help,

Dastnai

 

[Andrew Fergus]

Hello

How about an array formula like this? The formula assumes the dates are in ascending order in the range B1:G1 and the values are in the range B2:G2.
{=MIN(IF(ISNUMBER(B2:G2),B1:G1))}

Enter the formula without the curly brackets {} but instead of pressing enter, press Ctrl+Shift+Enter at the same time. You will know you have done this correctly when the curly brackets {} appear in the formula.

 

[Aladin Akyurek]

Control+shift+enter, not just enter:

=INDEX($B$1:$F$1,MATCH(TRUE,ISNUMBER(B2:F2),0))