"Spill error" Posting Values at first instance Problem with excel function

[Uncommon1]

Hello,
I have a hypothetical problem where I want a cash flow chart to post a purchase at a first instance where a down payment is met.
In this case B7 >= O17 then start a loan at that point in time

Cell B:18 = =INDEX($D$17:$BK$17,MATCH(TRUE,INDEX(($D$17:$BK$17>$B$7),),0))
Cell D:19 = =IF($B$18=D$17,SEQUENCE(1,$B$9*$B$11,$B$12*-1,0),0)

The function in D19 works if I only drag it to the cell its true. But if I drag it past I get the spill error. I would like this to be automatic due to varying items.

What can I put in D19 to make the payments start posting at the time the down payment is less than or equal to the values in row 17
I am a newbie at functions in excel but I am learning lots from you all.
Thanks,


Ultimately I want it to look like this:

What I am getting is this:

 

[Muhammad_Usman]

Just Apply Formula where you condition met .

Delete from next cell it will gives you result

 

[Peter_SSs]

Welcome to the MrExcel board!

For the future I suggest that you investigate XL2BB for providing sample data to make it easier for helpers by not having to manually type out sample data to test with.

See if this is the sort of thing you are after.
Notes:

• I have changed the duration to keep this mini sheet smaller
• In B19 I have offered an alternative to your B18 formula.
• Formula in D18 does not need to bee copied across.

23 10 14.xlsm
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X	Y	Z	AA	AB	AC	AD
2	Start	1/10/2023
3	Duration	12
7	DP Amount	175
12	Payment	6.59
17				15	30	45	60	75	90	105	120	135	150	165	180	195	210	225	240	255	270	285	300	315	330	345	360	375	390	405
18	First instance DP met	180		0	0	0	0	0	0	0	0	0	0	0	6.59	6.59	6.59	6.59	6.59	6.59	6.59	6.59	6.59	6.59	6.59	6.59	0	0	0	0
19		180
Uncommon1

Cell Formulas
Range	Formula
D18:BK18	D18	=LET(c,COLUMNS(D:BK),b,MATCH(B18,D17:BK17,0)-1,m,MIN(B3,c-b),a,c-b-m,p,TAKE(TRIM(TEXTSPLIT(REPT(B12&" ",c)," "))+0,,m),bp,IF(b=0,p,HSTACK(TAKE(TEXTSPLIT(TRIM(REPT("0 ",c))," ")+0,,b),p)),IF(a=0,bp,HSTACK(bp,TAKE(TEXTSPLIT(TRIM(REPT("0 ",c))," ")+0,,a))))
B18	B18	=INDEX($D$17:$BK$17,MATCH(TRUE,INDEX(($D$17:$BK$17>$B$7),),0))
B19	B19	=AGGREGATE(15,6,D17:BK17/(D17:BK17>=B7),1)
Dynamic array formulas.

 

[Uncommon1]

Thanks,
Not that I totally understand it yet, it works. I will dig in and try to understand the code. Thanks for your time.
I have tried the XL2BB and have yet to make it work. I still get an error that states "this filetype is not supported in Protected View"

 

[Peter_SSs]

it works. I will dig in and try to understand the code. Thanks for your time.

You're welcome. Thanks for the confirmation.

I have tried the XL2BB and have yet to make it work. I still get an error that states "this filetype is not supported in Protected View"

Sounds like you need to investigate the first bullet point (XL2BB Icons greyed out) in the 'Known XL2BB issues' section near the top of the instruction page.