Index first 0 but after a given date

[OilEconomist]

Thanks in advance for any suggestions. I will provide feedback.

What function would be able to obtain the date from Row 1 for the first 0 or blank in Rows 2, 3, and 4 but based on dates equal to or greater than the respective cell in Column A.

Manually obtaining them, it would be as follows:

• Row 2 for first zero or blank on or after 4/1/2019 would be 9/1/2019
• Row 3 for first zero or blank on or after 3/1/2019 would be 3/1/2019
• Row 4 for first zero or blank on or after 5/1/2019 would be 6/1/2019

Using the function INDEX( $D$1:$O$1, MATCH( 0, $D2:$O2, 0)) on any of the rows will always return 1/1/2019.


[TABLE="width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[TD]E[/TD]
[TD]F[/TD]
[TD]G[/TD]
[TD]H[/TD]
[TD]I[/TD]
[TD]J[/TD]
[TD]K[/TD]
[TD]L[/TD]
[TD]M[/TD]
[TD]N[/TD]
[TD]O[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]1/1/2019[/TD]
[TD]2/1/2019[/TD]
[TD]3/1/2019[/TD]
[TD]4/1/2019[/TD]
[TD]5/1/2019[/TD]
[TD]6/1/2019[/TD]
[TD]7/1/2019[/TD]
[TD]8/1/2019[/TD]
[TD]9/1/2019[/TD]
[TD]10/1/2019[/TD]
[TD]11/1/2019[/TD]
[TD]12/1/2019[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]4/1/2019[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]5[/TD]
[TD]4[/TD]
[TD]8[/TD]
[TD]8[/TD]
[TD]8[/TD]
[TD]7[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]3/1/2019[/TD]
[TD][/TD]
[TD][/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]7[/TD]
[TD]5[/TD]
[TD]6[/TD]
[TD]7[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]5/1/2019[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]2[/TD]
[TD]3[/TD]
[TD]88[/TD]
[TD]2[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[Fluff]

How about

Excel 2013/2016
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O
1				01/01/2019	02/01/2019	03/01/2019	04/01/2019	05/01/2019	06/01/2019	07/01/2019	08/01/2019	09/01/2019	10/01/2019	11/01/2019	12/01/2019
2	04/01/2019		09/01/2019			5	4	8	8	8	7
3	03/01/2019		08/01/2019	0	0	0	7	5	6	7	0	0	0	0	0
4	05/01/2019		06/01/2019		2	3	88	2
Output

Cell Formulas
Range	Formula
C2	{=INDEX($D$1:$O$1,MATCH(1,($D2:$O2=0)*($D$1:$O$1>$A2),0))}
Press CTRL+SHIFT+ENTER to enter array formulas.

 

[James006]

Hello,

You could test the following Array Formula

=INDEX($D$1:$O$1,MIN(IF($D$1:$O$1>=A2,IF(D2:O2=0,COLUMN($D$1:$O$1))))-3)

Hope this will help

 

[OilEconomist]

Thanks to both of you Fluff and James 006. Both proposed solutions worked.

The only thing I changed is ">" to ">=" as if a 0 fell on that date in column A, I wanted to know how to use it. I will be using both formulas and at times using it with ">" or ">=".

 

[James006]

You are welcome ...

 

[OilEconomist]

Just to be clear Fluff's (Post #2 ) and James006's (Post #3 ) worked.