3 payment some payments not made or paid in full

[CrashOD]

C5, C13 ect School Date
Im trying to have it check workbook for 2022
1. check workbook if cell C has "" then "Unpaid"
2. checks to see if D6 - D8 if F5<d6:d8 then pulls info from L in workbook for 2022 school (sometime people dont pay all three so some cells will not have a number why i was try sumif)
3. if f5>d6:d8 due to some payments being made but not all three then ="Short"
4. if all others fail because it was paid but not by partial payments but in full it looks at 2022 book and pulls info from C

i hope you can understand this if not please ask.

were pulls info into

(Not Done) Real Esate Taxes.xlsx
	A	B	C	D	E	F	G	H	I	J
1	Parcel	Property Location	Property Type	Property Description	Current Mailing	Apt	CITY, STATE, ZIP
2	015-02-007-100-A	920 E SUNBURY ST	RESIDENTIAL	LOT 28.5 X 115.10	920 E SUNBURY ST	SHAMOKIN PA 17872
3		NAME	DATE	BILL #	DISCOUNT	FACE	PENALTY	ASSESSMENT	NOTE	Special
4	2022 C&L	BAGLIEN SUZANNE LEONA	UNPAID	01500024	$741.24	$756.38	$832.03	$8,500
5	2022 SCHOOL	BAGLIEN SUZANNE LEONA	01/00/1900	01500022	$217.87	$222.32	$244.55	$8,500
6	2022 SCHOOL	Payment 1	8/3/2022#1	$74.12	FACE
7	2022 SCHOOL	Payment 2 (Penalty 9/15)	09/06/2022	$74.10	FACE
8	2022 SCHOOL	Payment 3 (Penalty 11/1)	10/03/2022	$74.10	FACE
9			Total Due	Paid In Full
10					015-02-007-100-A	011-01-003-054	010-01-002-223	017-01-009-218
11		NAME	DATE	BILL #	DISCOUNT	FACE	PENALTY	ASSESSMENT	NOTE	Special
12	2021 C&L	BAGLIEN SUZANNE LEONA	6/30/2021	01500025	$741.24	$756.38	$832.03	$8,500
13	2021 SCHOOL	BAGLIEN SUZANNE LEONA	#VALUE!	1500026	$225.13	$229.72	$252.69	$8,500
14	2021 SCHOOL	Payment 1
15	2021 SCHOOL	Payment 2 (Penalty 9/15)
16	2021 SCHOOL	Payment 3 (Penalty 11/1)
17			Total
Real Estate History

Cell Formulas
Range	Formula
B2	B2	=INDEX('[RLE_County Local 2022.xls]Real Estate'!$P$2:$R$7003,MATCH($A$2,'[RLE_County Local 2022.xls]Real Estate'!$P$2:$P$7003,0),3)
C2	C2	=INDEX('[RLE_County Local 2022.xls]Real Estate'!$P$2:$Q$7003,MATCH($A$2,'[RLE_County Local 2022.xls]Real Estate'!$P$2:$P$7003,0),2)
D2	D2	=INDEX('[RLE_County Local 2022.xls]Real Estate'!$P$2:$S$7003,MATCH($A$2,'[RLE_County Local 2022.xls]Real Estate'!$P$2:$P$7003,0),4)
E2	E2	=INDEX('[Rle_School 2022.xls]Real Estate'!$U$2:$Z$7003,MATCH($A$2,'[Rle_School 2022.xls]Real Estate'!$U$2:$U$7003,0),6)
F2	F2	=INDEX('[Rle_School 2022.xls]Real Estate'!$U$2:$AA$7003,MATCH($A$2,'[Rle_School 2022.xls]Real Estate'!$U$2:$U$7003,0),7)
G2	G2	=INDEX('[Rle_School 2022.xls]Real Estate'!$U$2:$AB$7003,MATCH($A$2,'[Rle_School 2022.xls]Real Estate'!$U$2:$U$7003,0),8)
B4	B4	=INDEX('[RLE_County Local 2022.xls]Real Estate'!$A$2:$P$7003,MATCH($A$2,'[RLE_County Local 2022.xls]Real Estate'!$P$2:$P$7003,0),1)
C4	C4	=IF(INDEX('[RLE_County Local 2022.xls]Real Estate'!$C$2:$P$7003,MATCH($A$2,'[RLE_County Local 2022.xls]Real Estate'!$P$2:$P$7003,0),1)="","UNPAID",INDEX('[RLE_County Local 2022.xls]Real Estate'!$C$2:$P$7003,MATCH($A$2,'[RLE_County Local 2022.xls]Real Estate'!$P$2:$P$7003,0),1))
D4	D4	=INDEX('[RLE_County Local 2022.xls]Real Estate'!$B$2:$P$7003,MATCH($A$2,'[RLE_County Local 2022.xls]Real Estate'!$P$2:$P$7003,0),1)
E4	E4	=INDEX('[RLE_County Local 2022.xls]Real Estate'!$H$2:$P$7003,MATCH($A$2,'[RLE_County Local 2022.xls]Real Estate'!$P$2:$P$7003,0),1)
F4	F4	=INDEX('[RLE_County Local 2022.xls]Real Estate'!$I$2:$P$7003,MATCH($A$2,'[RLE_County Local 2022.xls]Real Estate'!$P$2:$P$7003,0),1)
G4	G4	=INDEX('[RLE_County Local 2022.xls]Real Estate'!$J$2:$P$7003,MATCH($A$2,'[RLE_County Local 2022.xls]Real Estate'!$P$2:$P$7003,0),1)
H4	H4	=INDEX('[RLE_County Local 2022.xls]Real Estate'!$N$2:$P$7003,MATCH($A$2,'[RLE_County Local 2022.xls]Real Estate'!$P$2:$P$7003,0),1)
I4	I4	=IF(INDEX('[RLE_County Local 2022.xls]Real Estate'!$G$2:$P$7003,MATCH($A$2,'[RLE_County Local 2022.xls]Real Estate'!$P$2:$P$7003,0),1)="","",INDEX('[RLE_County Local 2022.xls]Real Estate'!$G$2:$P$7003,MATCH($A$2,'[RLE_County Local 2022.xls]Real Estate'!$P$2:$P$7003,0),1))
J4	J4	=IF(INDEX('[RLE_County Local 2022.xls]Real Estate'!$P$2:$T$7003,MATCH($A$2,'[RLE_County Local 2022.xls]Real Estate'!$P$2:$P$7003,0),1)="","",INDEX('[RLE_County Local 2022.xls]Real Estate'!$P$2:$T$7003,MATCH($A$2,'[RLE_County Local 2022.xls]Real Estate'!$P$2:$P$7003,0),5))
B5	B5	=INDEX('[Rle_School 2022.xls]Real Estate'!$A$2:$U$7003,MATCH($A$2,'[Rle_School 2022.xls]Real Estate'!$U$2:$U$7003,0),1)
C5	C5	=IF(INDEX('[Rle_School 2022.xls]Real Estate'!C$2:U$7003,MATCH($A$2,'[Rle_School 2022.xls]Real Estate'!$U$2:$U$7003,0),1)="","UNPAID",IF(F5<=SUMIF(C6:C8,"<>",D6:D8),INDEX('[Rle_School 2022.xls]Real Estate'!L$2:U$7003,MATCH($A$2,'[Rle_School 2022.xls]Real Estate'!$U$2:$U$7003,0),1),IF(D9="",INDEX('[Rle_School 2022.xls]Real Estate'!C$2:U$7003,MATCH($A$2,'[Rle_School 2022.xls]Real Estate'!$U$2:$U$7003,0),1),"SHORT")))
D5	D5	=INDEX('[Rle_School 2022.xls]Real Estate'!$B$2:$U$7003,MATCH($A$2,'[Rle_School 2022.xls]Real Estate'!$U$2:$U$7003,0),1)
E5	E5	=INDEX('[Rle_School 2022.xls]Real Estate'!$U$2:$AE$7003,MATCH($A$2,'[Rle_School 2022.xls]Real Estate'!$U$2:$U$7003,0),11)
F5	F5	=INDEX('[Rle_School 2022.xls]Real Estate'!$U$2:$AF$7003,MATCH($A$2,'[Rle_School 2022.xls]Real Estate'!$U$2:$U$7003,0),12)
G5	G5	=INDEX('[Rle_School 2022.xls]Real Estate'!$U$2:$AG$7003,MATCH($A$2,'[Rle_School 2022.xls]Real Estate'!$U$2:$U$7003,0),13)
H5	H5	=INDEX('[Rle_School 2022.xls]Real Estate'!$T$2:$U$7003,MATCH($A$2,'[Rle_School 2022.xls]Real Estate'!$U$2:$U$7003,0),1)
I5	I5	=IF(INDEX('[Rle_School 2022.xls]Real Estate'!$G$2:$U$7003,MATCH($A$2,'[Rle_School 2022.xls]Real Estate'!$U$2:$U$7003,0),1)="","",INDEX('[Rle_School 2022.xls]Real Estate'!$G$2:$U$7003,MATCH($A$2,'[Rle_School 2022.xls]Real Estate'!$U$2:$U$7003,0),1))
C6	C6	=IF(INDEX('[Rle_School 2022.xls]Real Estate'!$H$2:$U$7003,MATCH($A$2,'[Rle_School 2022.xls]Real Estate'!$U$2:$U$7003,0),1)="","",INDEX('[Rle_School 2022.xls]Real Estate'!$H$2:$U$7003,MATCH($A$2,'[Rle_School 2022.xls]Real Estate'!$U$2:$U$7003,0),1))
D6	D6	=IF(INDEX('[Rle_School 2022.xls]Real Estate'!$I$2:$U$7003,MATCH($A$2,'[Rle_School 2022.xls]Real Estate'!$U$2:$U$7003,0),1)="","",INDEX('[Rle_School 2022.xls]Real Estate'!$I$2:$U$7003,MATCH($A$2,'[Rle_School 2022.xls]Real Estate'!$U$2:$U$7003,0),1))
E6,E14	E6	=IF(C6="","",IF(C6>0,"FACE"))
C7	C7	=IF(INDEX('[Rle_School 2022.xls]Real Estate'!$J$2:$AN$7003,MATCH($A$2,'[Rle_School 2022.xls]Real Estate'!$AN$2:$AN$7003,0),1)="","",INDEX('[Rle_School 2022.xls]Real Estate'!$J2:$AN$7003,MATCH($A$2,'[Rle_School 2022.xls]Real Estate'!$AN$2:$AN$7003,0),1))
D7	D7	=IF(INDEX('[Rle_School 2022.xls]Real Estate'!$K$2:$AN$7003,MATCH($A$2,'[Rle_School 2022.xls]Real Estate'!$AN$2:$AN$7003,0),1)="","",INDEX('[Rle_School 2022.xls]Real Estate'!$K$2:$AN$7003,MATCH($A$2,'[Rle_School 2022.xls]Real Estate'!$AN$2:$AN$7003,0),1))
E15,E7:E8	E7	=IF(D6="","",IF(C5="UNPAID","",IF(D7="","",IF(D6>=D7,"FACE",IF(D6<D7,"PENALTY")))))
C8	C8	=IF(INDEX('[Rle_School 2022.xls]Real Estate'!$L$2:$AO$7003,MATCH($A$2,'[Rle_School 2022.xls]Real Estate'!$AO$2:$AO$7003,0),1)="","",INDEX('[Rle_School 2022.xls]Real Estate'!$L$2:$AO$7003,MATCH($A$2,'[Rle_School 2022.xls]Real Estate'!$AO$2:$AO$7003,0),1))
D8	D8	=IF(INDEX('[Rle_School 2022.xls]Real Estate'!$M$2:$AO$7003,MATCH($A$2,'[Rle_School 2022.xls]Real Estate'!$AO$2:$AO$7003,0),1)="","",IF(INDEX('[Rle_School 2022.xls]Real Estate'!$M$2:$AO$7003,MATCH($A$2,'[Rle_School 2022.xls]Real Estate'!$AO$2:$AO$7003,0),1)>0,INDEX('[Rle_School 2022.xls]Real Estate'!$M$2:$AO$7003,MATCH($A$2,'[Rle_School 2022.xls]Real Estate'!$AO$2:$AO$7003,0),1),""))
D9	D9	=IF(D6="","",IF(SUMIF(C6:C8,"<>",D6:D8)>=F5,"Paid In Full",IF(F5>SUMIF(C6:C8,"<>",D6:D8),SUMIF(C6:C8,"<>",D6:D8)-F5,"help")))
E9,E17	E9	=IF($D9>=0,"","SHORT in Face")
F9	F9	=IF(D6="","",IF(F5<=SUM(D6,D7,D8),"",IF(SUM(F5,-N(D6),-N(D7),-N(D8))<0.03,"Paid In Full",IF(F5>SUM(D6,D8,D8),SUM(F5,-N(D32),-N(D6),-N(D7)),"help"))))
D12	D12	=INDEX('C&L 2021'!$B$2:$P$7003,MATCH($A$2,'C&L 2021'!$L$2:$L$7003,0),1)
E12	E12	=INDEX('C&L 2021'!$H$2:$P$7003,MATCH($A$2,'C&L 2021'!$L$2:$L$7003,0),1)
F12	F12	=INDEX('C&L 2021'!$I$2:$P$7003,MATCH($A$2,'C&L 2021'!$L$2:$L$7003,0),1)
G12	G12	=INDEX('C&L 2021'!$J$2:$P$7003,MATCH($A$2,'C&L 2021'!$L$2:$L$7003,0),1)
H12	H12	=INDEX('C&L 2021'!$K$2:$P$7003,MATCH($A$2,'C&L 2021'!$L$2:$L$7003,0),1)
I12	I12	=IF(INDEX('C&L 2021'!$G$2:$P$7003,MATCH($A$2,'C&L 2021'!$L$2:$L$7003,0),1)="","",INDEX('C&L 2021'!$G$2:$P$7003,MATCH($A$2,'C&L 2021'!$L$2:$L$7003,0),1))
J12	J12	=IF(INDEX('C&L 2021'!$L$2:$P$7003,MATCH($A$2,'C&L 2021'!$L$2:$L$7003,0),1)="","",INDEX('C&L 2021'!$L$2:$P$7003,MATCH($A$2,'C&L 2021'!$L$2:$L$7003,0),5))
B12	B12	=INDEX('C&L 2021'!$A$2:$P$7003,MATCH($A$2,'C&L 2021'!$L$2:$L$7003,0),1)
B13	B13	=INDEX('SK 2021'!$A$2:$U$6959,MATCH($A$2,'SK 2021'!$U$2:$U$6959,0),1)
D13	D13	=INDEX('SK 2021'!$B$2:$U$6959,MATCH($A$2,'SK 2021'!$U$2:$U$6959,0),1)
E13	E13	=INDEX('SK 2021'!$U$2:$Y$6959,MATCH($A$2,'SK 2021'!$U$2:$U$6959,0),5)
F13	F13	=INDEX('SK 2021'!$U$2:$Z$6959,MATCH($A$2,'SK 2021'!$U$2:$U$6959,0),6)
G13	G13	=INDEX('SK 2021'!$U$2:$AA$6959,MATCH($A$2,'SK 2021'!$U$2:$U$6959,0),7)
H13	H13	=INDEX('SK 2021'!$T$2:$U$6959,MATCH($A$2,'SK 2021'!$U$2:$U$6959,0),1)
I13	I13	=IF(INDEX('SK 2021'!$G$2:$U$6959,MATCH($A$2,'SK 2021'!$U$2:$U$6959,0),1)="","",INDEX('SK 2021'!$G$2:$U$6959,MATCH($A$2,'SK 2021'!$U$2:$U$6959,0),1))
D14	D14	=IF(INDEX('SK 2021'!$I$2:$U$6959,MATCH($A$2,'SK 2021'!$U$2:$U$6959,0),1)="","",INDEX('SK 2021'!$I$2:$U$6959,MATCH($A$2,'SK 2021'!$U$2:$U$6959,0),1))
D15	D15	=IF(INDEX('SK 2021'!$K$2:$U$6959,MATCH($A$2,'SK 2021'!$U$2:$U$6959,0),1)="","",INDEX('SK 2021'!$K$2:$U$6959,MATCH($A$2,'SK 2021'!$U$2:$U$6959,0),1))
D16	D16	=IF(INDEX('SK 2021'!$L$2:$U$6959,MATCH($A$2,'SK 2021'!$U$2:$U$6959,0),1)="","",INDEX('SK 2021'!$L$2:$U$6959,MATCH($A$2,'SK 2021'!$U$2:$U$6959,0),1))
E16	E16	=IF(D15="","",IF(C14="UNPAID","",IF(D16="","",IF(D14>=D16,"FACE",IF(D14<D16,"PENALTY")))))
D17	D17	=IF(SUMIF(C14:C16,"<>",D14:D16)=0,"",IF(SUMIF(C14:C16,"<>",D14:D16)>=F13,"Paid In Full",IF(F13>SUMIF(C14:C16,"<>",D14:D16),SUMIF(C14:C16,"<>",D14:D16)-F13,"help")))
C12	C12	=IF(INDEX('C&L 2021'!$C$2:$P$7003,MATCH($A$2,'C&L 2021'!$L$2:$L$7003,0),1)="","UNPAID",INDEX('C&L 2021'!$C$2:$P$7003,MATCH($A$2,'C&L 2021'!$L$2:$L$7003,0),1))
C13	C13	=IF(INDEX('SK 2021'!$C$2:$U$6959,MATCH($A$2,'SK 2021'!$U$2:$U$6959,0),1)="","UNPAID",IF(F13<=SUMIF(C14:C16,"<>",D14:D16),INDEX('SK 2021'!$L$2:$U$6959,MATCH($A$2,'SK 2021'!$U$2:$U$6959,0),1),IF(D17="",INDEX('SK 2021'!$C$2:$U$6959,MATCH($A$2,'SK 2021'!$U$2:$U$6959,0),1,"SHORT"))))
C14	C14	=IF(INDEX('SK 2021'!$H$2:$U$6959,MATCH($A$2,'SK 2021'!$U$2:$U$6959,0),1)="","",INDEX('SK 2021'!$H$2:$U$6959,MATCH($A$2,'SK 2021'!$U$2:$U$6959,0),1))
C15	C15	=IF(INDEX('SK 2021'!$J$2:$U$6959,MATCH($A$2,'SK 2021'!$U$2:$U$6959,0),1)="","",INDEX('SK 2021'!$J$2:$U$6959,MATCH($A$2,'SK 2021'!$U$2:$U$6959,0),1))
C16	C16	=IF(INDEX('SK 2021'!$L$2:$U$6959,MATCH($A$2,'SK 2021'!$U$2:$U$6959,0),1)="","",INDEX('SK 2021'!$K$2:$U$6959,MATCH($A$2,'SK 2021'!$U$2:$U$6959,0),1))

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
D17	Cell Value	<0	text	NO
D9	Cell Value	<0	text	NO

2021 School

(Not Done) Real Esate Taxes.xlsx
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U
3315	BAGLIEN SUZANNE LEONA	1500026	12/03/2021	P	250									225.13	229.72	252.69	15	65	01512-4	8500	015-02-007-100-A
SK 2021

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
U4017:U4192,U2479:U2518,U575:U827,U3:U573,U1092:U1124,U830:U1090,U1126:U1294,U1380:U1428,U1431:U1532,U1704:U1736,U1535:U1629,U1738:U1832,U1834:U2302,U2306:U2315,U2328:U2357,U2359:U2371,U2379:U2387,U2389:U2405,U2407:U2414,U2416:U2441,U2461:U2476,U2321:U2326	Cell Value	duplicates	text	NO

2022 School 3 payments

Payment 1

Rle_School 2022.xls
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P				T	U	V	W			Z	AA	AB						AH	AI	AJ	AK	AL	AM	AN	AO	AP	AQ	AR	AS	AT	AU	AV	AW	AX	AY	AZ	BA	BB	BC	BD	BE	BF	BG	BH	BI	BJ	BK	BL	BM	BN	BO	BP	BQ	BR	BS	BT	BU	BV	BW	BX	BY	BZ	CA	CB	CC	CD	CE	CF	CG	CH	CI	CJ	CK	CL	CM	CN	CO	CP	CQ	CR	CS	CT	CU	CV	CW	CX	CY	CZ	DA	DB	DC	DD	DE	DF	DG	DH	DI	DJ	DK	DL	DM	DN	DO	DP	DQ	DR	DS	DT	DU	DV	DW	DX	DY	DZ	EA	EB	EC	ED	EE	EF	EG	EH	EI	EJ	EK	EL	EM	EN	EO	EP	EQ	ER	ES	ET	EU	EV	EW	EX	EY	EZ	FA	FB	FC	FD	FE	FF	FG	FH	FI	FJ	FK	FL	FM	FN	FO	FP	FQ	FR	FS	FT	FU	FV	FW	FX	FY	FZ	GA	GB	GC	GD	GE	GF	GG	GH	GI	GJ	GK	GL	GM	GN	GO	GP	GQ	GR	GS	GT	GU	GV	GW	GX	GY	GZ	HA	HB	HC	HD	HE	HF	HG	HH	HI	HJ	HK	HL	HM	HN	HO	HP	HQ	HR	HS	HT	HU	HV	HW	HX	HY	HZ	IA	IB	IC	ID	IE	IF	IG	IH	II	IJ	IK	IL	IM	IN	IO	IP	IQ	IR	IS	IT	IU	IV
927	BAGLIEN SUZANNE LEONA	01500022	8/3/2022	F	221	#1 - PARTIAL PAY		8/3/2022#1	74.12					$217.87	$222.32	$244.55				8500	015-02-007-100-A	Removed Personal Info	LOT 28.5 X 115.10			Removed Personal Info	Removed Personal Info							8500	YES
Real Estate

Cell Formulas
Range	Formula
AI927	AI927	=IF(AH927, "YES", "NO")

Payment 2

Rle_School 2022.xls
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P				T	U	V	W			Z	AA	AB						AH	AI	AJ	AK	AL	AM	AN	AO	AP	AQ	AR	AS	AT	AU	AV	AW	AX	AY	AZ	BA	BB	BC	BD	BE	BF	BG	BH	BI	BJ	BK	BL	BM	BN	BO	BP	BQ	BR	BS	BT	BU	BV	BW	BX	BY	BZ	CA	CB	CC	CD	CE	CF	CG	CH	CI	CJ	CK	CL	CM	CN	CO	CP	CQ	CR	CS	CT	CU	CV	CW	CX	CY	CZ	DA	DB	DC	DD	DE	DF	DG	DH	DI	DJ	DK	DL	DM	DN	DO	DP	DQ	DR	DS	DT	DU	DV	DW	DX	DY	DZ	EA	EB	EC	ED	EE	EF	EG	EH	EI	EJ	EK	EL	EM	EN	EO	EP	EQ	ER	ES	ET	EU	EV	EW	EX	EY	EZ	FA	FB	FC	FD	FE	FF	FG	FH	FI	FJ	FK	FL	FM	FN	FO	FP	FQ	FR	FS	FT	FU	FV	FW	FX	FY	FZ	GA	GB	GC	GD	GE	GF	GG	GH	GI	GJ	GK	GL	GM	GN	GO	GP	GQ	GR	GS	GT	GU	GV	GW	GX	GY	GZ	HA	HB	HC	HD	HE	HF	HG	HH	HI	HJ	HK	HL	HM	HN	HO	HP	HQ	HR	HS	HT	HU	HV	HW	HX	HY	HZ	IA	IB	IC	ID	IE	IF	IG	IH	II	IJ	IK	IL	IM	IN	IO	IP	IQ	IR	IS	IT	IU	IV
2349	BAGLIEN SUZANNE LEONA	01500022	9/6/2022	F	223			8/3/2022#1	74.12	09/06/22	74.1			$217.87	$74.10	$244.55				8500	015-02-007-100-A	Removed Personal Info	LOT 28.5 X 115.10			Removed Personal Info	Removed Personal Info							8500	YES					015-02-007-100-A
Real Estate

Cell Formulas
Range	Formula
O2349	O2349	=K2349
AI2349	AI2349	=IF(AH2349, "YES", "NO")

Payment 3

Rle_School 2022.xls
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P				T	U	V	W			Z	AA	AB						AH	AI	AJ	AK	AL	AM	AN	AO	AP	AQ	AR	AS	AT	AU	AV	AW	AX	AY	AZ	BA	BB	BC	BD	BE	BF	BG	BH	BI	BJ	BK	BL	BM	BN	BO	BP	BQ	BR	BS	BT	BU	BV	BW	BX	BY	BZ	CA	CB	CC	CD	CE	CF	CG	CH	CI	CJ	CK	CL	CM	CN	CO	CP	CQ	CR	CS	CT	CU	CV	CW	CX	CY	CZ	DA	DB	DC	DD	DE	DF	DG	DH	DI	DJ	DK	DL	DM	DN	DO	DP	DQ	DR	DS	DT	DU	DV	DW	DX	DY	DZ	EA	EB	EC	ED	EE	EF	EG	EH	EI	EJ	EK	EL	EM	EN	EO	EP	EQ	ER	ES	ET	EU	EV	EW	EX	EY	EZ	FA	FB	FC	FD	FE	FF	FG	FH	FI	FJ	FK	FL	FM	FN	FO	FP	FQ	FR	FS	FT	FU	FV	FW	FX	FY	FZ	GA	GB	GC	GD	GE	GF	GG	GH	GI	GJ	GK	GL	GM	GN	GO	GP	GQ	GR	GS	GT	GU	GV	GW	GX	GY	GZ	HA	HB	HC	HD	HE	HF	HG	HH	HI	HJ	HK	HL	HM	HN	HO	HP	HQ	HR	HS	HT	HU	HV	HW	HX	HY	HZ	IA	IB	IC	ID	IE	IF	IG	IH	II	IJ	IK	IL	IM	IN	IO	IP	IQ	IR	IS	IT	IU	IV
2482	BAGLIEN SUZANNE LEONA	01500022	10/3/2022	F	224	#2	THERE WAS OVER PAYMENT ON BILL OF $7.41 APPLIED TO COUNTY & LOCAL PARTIAL PAY	8/3/2022#1	74.12	09/06/22	74.1	10/03/22	74.1	$217.87	$74.10	$244.55				8500	015-02-007-100-A	Removed Personal Info	LOT 28.5 X 115.10			Removed Personal Info	Removed Personal Info							8500	YES						015-02-007-100-A
Real Estate

Cell Formulas
Range	Formula
O2482	O2482	=K2482
AI2482	AI2482	=IF(AH2482, "YES", "NO")

 

[CrashOD]

=IF(INDEX('[Rle_School 2022.xls]Real Estate'!C$2:U$7003,MATCH($A$2,'[Rle_School 2022.xls]Real Estate'!$U$2:$U$7003,0),1)="","UNPAID",IF(D9="Paid In Full",C8, if(D9="",INDEX('[Rle_School 2022.xls]Real Estate'!C$2:U$7003,MATCH($A$2,'[Rle_School 2022.xls]Real Estate'!$U$2:$U$7003,0),1), "Short")))

doing it this way may of fixed my problem/ do you see were a problem may happen?