Multiple Matches but only pulling 1st one

[CrashOD]

tried doing this codes looking for
C12 ' is the value i'm wanting to search for were they can be multi matches if there is i need B44-B46, D44-D46 have values in there
'SK Real Estate'!$U:$U ' is the location to look for the info to match to (C12)

B44 ' should show SK Real Estate'!$H:$H
'SK Real Estate'!$H:$H ' (Date) is the value i want returned if there is a value

B45 ' should show 'SK Real Estate'!$J:$J
'SK Real Estate'!$J:$J ' (Date) is the value i want returned if there is a value

B46 ' should show 'SK Real Estate'!$L:$L
'SK Real Estate'!$L:$L ' (Date) is the value i want returned if there is a value

D44 ' should show SK Real Estate'!$I:$I
'SK Real Estate'!$I:$I ' (Amount) is the value i want returned if there is a value

D45 ' should show 'SK Real Estate'!$K:$K
'SK Real Estate'!$K:$K ' (Amount) is the value i want returned if there is a value

D46 ' should show 'SK Real Estate'!$M:$M
'SK Real Estate'!$M:$M ' (Amount) is the value i want returned if there is a value

I tried the below codes with no luck. B44 & D44 get filled in but nothing more. on the picture below with the black boxes line 1170 in $U matches for the 2nd time witch should fill in B45 & d45 for 2nd payment.

=IF(ISNUMBER(MATCH('SK Real Estate'!$A:$U, $C$12)), MATCH($C$12('SK Real Estate'!$A:$U), ROW('SK Real Estate'!$A:$U)), "")

=INDEX('SK Real Estate'!$A:$U,MATCH(C12,'SK Real Estate'!$U:$U,0),8)

=IFERROR(INDEX('SK Real Estate'!$H:$H, SMALL(IF($C$12='SK Real Estate'!$U:$U, ROW('SK Real Estate'!$U:$U)-ROW('SK Real Estate'!$U)+1), ROW(1:1))),"" )


this picture shows were im pulling data from (this exact sheet in in the same workbook im looking to put code in. why i used 'SK Real Estate'! and not reference a workbook then sheet

the picture below is were im doing the code for B44:B46 & D44:d46. yes the total due is wrong for face changing code to pull the other amount on sheet should be

321.41​

327.97​

360.77​

Thanks so much for any help!

 

[KRice]

You have posted rows 8:10 of the SK Real Estate 2 sheet again. I do not see where that information is related to what you are trying to do.

Once again, what is in cell C12 on the Tax Cert Form sheet?

 

[CrashOD]

Automated 2022 Tax Certification Form.xlsm
	C
12	013-02-005-317
Tax Cert Form 2022-2021 (2)

Cell Formulas
Range	Formula
C12	C12	='Tax Cert Bill'!B17

 

[KRice]

Thank you. So C12 is "013-02-005-317". And if you manually search down column U of SK Real Estate 2, is row 8 where you first encounter "013-02-005-317"?

If so, then check your formulas. I see inconsistencies in them, where the ranges are not the same.

I mentioned in posts #14 and #16 the importance of maintaining consistency in the formula ranges.

 

[KRice]

Let's go back to post #12 where I recommended for the B44 formula (which should be for Dates):
=IFERROR(IF(ROWS(B$44:B44)<=COUNTA(INDEX('SK Real Estate'!$H$3:$M$100,MATCH($C$12,'SK Real Estate'!$U$3:$U$100,0),))/2, INDEX('SK Real Estate'!$H$3:$M$100,MATCH($C$12,'SK Real Estate'!$U$3:$U$100,0),2*ROWS(B$44:B44)-1),""),"")

In post #20, you are now showing this for the C44 formula (appears that you have moved the Date column to C):
=IFERROR(IF(ROWS(B$44:B44)<=COUNTA(INDEX('SK Real Estate 2'!$H1:$M$6987,MATCH($C$12,'SK Real Estate 2'!$U$1:$U$6987,0),))/2, INDEX('SK Real Estate 2'!$H$1:$M$6987,MATCH($C$12,'SK Real Estate 2'!$U$1:$U$6987,0),2*ROWS(B$44:B44)-1),""),"")

Notice the 1st red range...you do not have it "fixed". There should be a $ sign on both the column and row description $H$1. But I thought you were planning to pick a larger, easier to examine upper range, such as 7000. And if your data begin on row 3, I would recommend using that rather than row 1 of the spreadsheet...
then the C44 formula would be:
=IFERROR(IF(ROWS(C$44:C44)<=COUNTA(INDEX('SK Real Estate 2'!$H$3:$M$7000,MATCH($C$12,'SK Real Estate 2'!$U$3:$U$7000,0),))/2, INDEX('SK Real Estate 2'!$H$3:$M$7000,MATCH($C$12,'SK Real Estate 2'!$U$3:$U$7000,0),2*ROWS(C$44:C44)-1),""),"")


Your D44 formula is this...
=IFERROR(IF(ROWS(D$44:D44)<=COUNTA(INDEX('SK Real Estate 2'!$H$1:$M$6987,MATCH($C$12,'SK Real Estate 2'!$U$1:$U$6987,0),))/2, INDEX('SK Real Estate 2'!$H$1:$M$6987,MATCH($C$12,'SK Real Estate 2'!$U$1:$U$6987,0),2*ROWS(D$44:D44)),""),"" )

while the D45 formula is this...
=IFERROR(IF(ROWS(D$44:D45)<=COUNTA(INDEX('SK Real Estate 2'!$H$2:$M$7000,MATCH($C$12,'SK Real Estate 2'!$U$2:$U$7000,0),))/2, INDEX('SK Real Estate 2'!$H$2:$M$7000,MATCH($C$12,'SK Real Estate 2'!$U$2:$U$7000,0),2*ROWS(D$44:D45)),""),"" )

There is a different issue here: You have all of the ranges fixed with $ signs, which is good. But you've changed the formula between D44 and D45, which is bad. The indexes to the information are off by one because one starts at row 1 on the sheet while the other starts at row 2. This is why I would strongly recommend that you index your data beginning in the worksheet row number where the first data point is found. If that is row 3...
then the D44 formula would be:
=IFERROR(IF(ROWS(D$44:D44)<=COUNTA(INDEX('SK Real Estate 2'!$H$3:$M$7000,MATCH($C$12,'SK Real Estate 2'!$U$3:$U$7000,0),))/2, INDEX('SK Real Estate 2'!$H$3:$M$7000,MATCH($C$12,'SK Real Estate 2'!$U$3:$U$7000,0),2*ROWS(D$44:D44)),""),"" )

Please compare the two formulas above that follow the bold font and you should see that they are nearly identical and all of the colored font ranges are the same and fixed with $ signs. These formulas are copied into C44 and D44 respectively and then copied down.

 

[CrashOD]

Automated 2022 Tax Certification Form.xlsm
	A	B	C	D	E
38	SCHOOL 2021		July/Aug	Sept/Oct	Nov/Dec
39			Discount (-2%)	Face:	Penalty (+10%)
40		PAID	$64.07	$65.38	$71.92
41	Date Paid:	10/18/2021		HomeStead	Assessed Value
42				NO	1,810
43		PARTIALS	DATE	$0.00	<- SHORT IN FACE
44		PAYMENT #1	09/15/2021	$21.79	FACE
45		PAYMENT #2	10/18/2021	$21.79	FACE
46		PAYMENT #3		$21.79
Tax Cert Form 2022-2021 (2)

Cell Formulas
Range	Formula
C40	C40	=INDEX('SK Real Estate 2'!$A:$AK,MATCH(C12,'SK Real Estate 2'!$U:$U,0),31)
D40	D40	=INDEX('SK Real Estate 2'!$A:$AK,MATCH(C12,'SK Real Estate 2'!$U:$U,0),32)
E40	E40	=INDEX('SK Real Estate 2'!$A:$AK,MATCH(C12,'SK Real Estate 2'!$U:$U,0),33)
B40	B40	=IF(B41="","UNPAID",IF(B41="EXONERATED","PER COUNTY",IF(B41="Tax Claims", "SHORT", "PAID")))
B41	B41	=IF(D43=0, INDEX('SK Real Estate 2'!$A:$U,MATCH(C12,'SK Real Estate 2'!$U:$U,0),3), IF(D43<=0,C46,IF(D40>D43,"Tax Claims",INDEX('SK Real Estate 2'!$A:$U,MATCH(C12,'SK Real Estate 2'!$U:$U,0),3))))
E42	E42	=INDEX('SK Real Estate 2'!$A:$U,MATCH(C12,'SK Real Estate 2'!$U:$U,0),20)
D42	D42	=INDEX('SK Real Estate 2'!$A:$AI,MATCH(C12,'SK Real Estate 2'!$U:$U,0),35)
D43	D43	=IF(D40<=SUM(D44,D45,D46),0,IF(SUM(D40,-N(D44),-N(D45),-N(D46))<=0.02,0,IF(D40>=SUM(D44,D45,D46),SUM(D40,-N(D44),-N(D45),-N(D46)),"help")))
C44:C46	C44	=IFERROR(IF(ROWS(C$44:C44)<=COUNTA(INDEX('SK Real Estate 2'!$H2:$M$7000,MATCH($C$12,'SK Real Estate 2'!$U$2:$U$7000,0),))/2, INDEX('SK Real Estate 2'!$H$2:$M$7000,MATCH($C$12,'SK Real Estate 2'!$U$2:$U$7000,0),2*ROWS(C$44:C44)-1),""),"")
D44:D46	D44	=IFERROR(IF(ROWS(D$44:D44)<=COUNTA(INDEX('SK Real Estate 2'!$H$2:$M$7000,MATCH($C$12,'SK Real Estate 2'!$U$2:$U$7000,0),))/2, INDEX('SK Real Estate 2'!$H$2:$M$7000,MATCH($C$12,'SK Real Estate 2'!$U$2:$U$7000,0),2*ROWS(D$44:D44)),""),"" )
E44	E44	=IF(C44="","", "FACE")
E45	E45	=IF(C45="","",IF(D45=0,"UNPAID",IF(D45<=D44,"FACE",IF(D44>D45,"PENALTY"))))
E46	E46	=IF(C46="","",IF(D46=0,"UNPAID",IF(D46<=D44,"FACE",IF(D44>D46,"PENALTY"))))

Named Ranges
Name	Refers To	Cells
'SK Real Estate 2'!CSV49XLS_7	='SK Real Estate 2'!$A$2:$AG$4211	B41, D42:E42, C40:E40

starts on 2 top row is description.

 

[KRice]

Please review my last post carefully. There are still some issues.

 

[CrashOD]

fixing again noticed i forgot $before number and it is why it starting some higher

Automated 2022 Tax Certification Form.xlsm
	A	B	C	D	E
38	SCHOOL 2021		July/Aug	Sept/Oct	Nov/Dec
39			Discount (-2%)	Face:	Penalty (+10%)
40		PAID	$64.07	$65.38	$71.92
41	Date Paid:	10/18/2021		HomeStead	Assessed Value
42				NO	1,810
43		PARTIALS	DATE	$0.00	<- SHORT IN FACE
44		PAYMENT #1	09/15/2021	$21.79	FACE
45		PAYMENT #2	10/18/2021	$21.79	FACE
46		PAYMENT #3	10/29/2021	$21.79	FACE
Tax Cert Form 2022-2021 (2)

Cell Formulas
Range	Formula
C40	C40	=INDEX('SK Real Estate 2'!$A:$AK,MATCH(C12,'SK Real Estate 2'!$U:$U,0),31)
D40	D40	=INDEX('SK Real Estate 2'!$A:$AK,MATCH(C12,'SK Real Estate 2'!$U:$U,0),32)
E40	E40	=INDEX('SK Real Estate 2'!$A:$AK,MATCH(C12,'SK Real Estate 2'!$U:$U,0),33)
B40	B40	=IF(B41="","UNPAID",IF(B41="EXONERATED","PER COUNTY",IF(B41="Tax Claims", "SHORT", "PAID")))
B41	B41	=IF(D43=0, INDEX('SK Real Estate 2'!$A:$U,MATCH(C12,'SK Real Estate 2'!$U:$U,0),3), IF(D43<=0,C46,IF(D40>D43,"Tax Claims",INDEX('SK Real Estate 2'!$A:$U,MATCH(C12,'SK Real Estate 2'!$U:$U,0),3))))
E42	E42	=INDEX('SK Real Estate 2'!$A:$U,MATCH(C12,'SK Real Estate 2'!$U:$U,0),20)
D42	D42	=INDEX('SK Real Estate 2'!$A:$AI,MATCH(C12,'SK Real Estate 2'!$U:$U,0),35)
D43	D43	=IF(D40<=SUM(D44,D45,D46),0,IF(SUM(D40,-N(D44),-N(D45),-N(D46))<=0.02,0,IF(D40>=SUM(D44,D45,D46),SUM(D40,-N(D44),-N(D45),-N(D46)),"help")))
C44:C46	C44	=IFERROR(IF(ROWS(C$44:C44)<=COUNTA(INDEX('SK Real Estate 2'!$H$2:$M$7000,MATCH($C$12,'SK Real Estate 2'!$U$2:$U$7000,0),))/2, INDEX('SK Real Estate 2'!$H$2:$M$7000,MATCH($C$12,'SK Real Estate 2'!$U$2:$U$7000,0),2*ROWS(C$44:C44)-1),""),"")
D44:D46	D44	=IFERROR(IF(ROWS(D$44:D44)<=COUNTA(INDEX('SK Real Estate 2'!$H$2:$M$7000,MATCH($C$12,'SK Real Estate 2'!$U$2:$U$7000,0),))/2, INDEX('SK Real Estate 2'!$H$2:$M$7000,MATCH($C$12,'SK Real Estate 2'!$U$2:$U$7000,0),2*ROWS(D$44:D44)),""),"" )
E44	E44	=IF(C44="","", "FACE")
E45	E45	=IF(C45="","",IF(D45=0,"UNPAID",IF(D45<=D44,"FACE",IF(D44>D45,"PENALTY"))))
E46	E46	=IF(C46="","",IF(D46=0,"UNPAID",IF(D46<=D44,"FACE",IF(D44>D46,"PENALTY"))))

Named Ranges
Name	Refers To	Cells
'SK Real Estate 2'!CSV49XLS_7	='SK Real Estate 2'!$A$2:$AG$4211	B41, D42:E42, C40:E40

fixed just becouse i for got $ it climed in numbers when copied it down.

 

[KRice]

Yes, that's correct. Looks like you have it fixed now!

By the way, the D43 formula:
IF(D40<=SUM(D44,D45,D46),0,IF(SUM(D40,-N(D44),-N(D45),-N(D46))<=0.02,0,IF(D40>=SUM(D44,D45,D46),SUM(D40,-N(D44),-N(D45),-N(D46)),"help")))
does not need to have the N function and the SUM range can be a continuous range...so this should work fine:

IF(D40<=SUM(D44:D46),0,IF(SUM(D40,-D44:D46)<=0.02,0,IF(D40>=SUM(D44:D46),SUM(D40,-D44:D46),"help")))

 

[CrashOD]

Yes, that's correct. Looks like you have it fixed now!

thanks im changing all my other stuff to add $ and put range to 7000 instead of just the letter. thanks so much!

 

[CrashOD]

thanks so much. this workbook has input box to ask parcel, requestor, if paid, date. then it pulls the data from the newest workbook then opens chrome to tax claims site copies page (still can not get it to close like ie did yet), prints tax cert to pdf, then new e-mail and puts the pdf in it and past info from tax claims site most of time pastes but is not i just ctrl+V. then the sheets pull the info from the workbooks. i learned alot in vba. then then the other two sheets pull the data in for the tax cert. i change coding from A:U to the first column it would need to look in for the formula thanks to you!. guess will help alot in speed not that it is slow. here is the code for the other parts since changing it every were.

Automated 2022 Tax Certification Form.xlsm
	A	B	C	D	E
20	COUNTY/LOCAL 2022		3/1-4/30	5/1-6/30	7/1-12/31
21	Bill #:	01300699	Discount (-2%)	Face:	Penalty (+10%)
22		PAID	$157.83	$161.06	$177.18
23	Date Paid:	3/4/2022			Assessed Value
24					1,810
25
26	SCHOOL 2022		July/Aug	Sept/Oct	Nov/Dec
27	Bill #:	=INDEX('[2022 - School - Real Estate.xls]Real Estate'!$B$2:$P$7000,MATCH($C$12,'[2022 - School - Real Estate.xls]Real Estate'!$P$2:$P$2,0),1)	Discount (-2%)	Face:	Penalty (+10%)
28		=IF(B29="", "UNPAID", "PAID")	=INDEX('[2022 - School - Real Estate.xls]Real Estate'!$U$2:$AK$7000,MATCH($C$12,'[2022 - School - Real Estate.xls]Real Estate'!$U$2:$AK$7000,0),11)	=INDEX('[2022 - School - Real Estate.xls]Real Estate'!$U$2:$AK$7000,MATCH($C$12,'[2022 - School - Real Estate.xls]Real Estate'!$U$2:$AK$7000,0),12)	=INDEX('[2022 - School - Real Estate.xls]Real Estate'!$U$2:$AK$7000,MATCH($C$12,'[2022 - School - Real Estate.xls]Real Estate'!$U$2:$AK$7000,0),13)
29	Date Paid:	=IF(D31=0, INDEX('[2022 - School - Real Estate.xls]Real Estate'!$C$2:$U$7000,MATCH($C$12,'[2022 - School - Real Estate.xls]Real Estate'!$U$2:$U$7000,0),3), IF(D28<=0,C34,IF(D28>D31,"Tax Claims",INDEX('[2022 - School - Real Estate.xls]Real Estate!$C$2:$U$7000,MATCH($C$12,'[2022 - School - Real Estate.xls]Real Estate'!$U$2:$U$7000,0),1))))		HomeStead	Assessed Value
30		Not Realeased Till July		=INDEX('[2022 - School - Real Estate.xls]Real Estate'!$U$2:$AI$7000,MATCH($C$12,'[2022 - School - Real Estate.xls]Real Estate'!$U$2:$U$7000,0),15)	=INDEX('[2022 - School - Real Estate.xls]Real Estate'!$T$2:$P$7000,MATCH($C$12,'[2022 - School - Real Estate.xls]Real Estate'!$T$2:$P$7000,0),1)
31		PARTIALS	DATE	$0.00	<- SHORT IN FACE
32		PAYMENT #1	=IFERROR(IF(ROWS($C$32:C32)<=COUNTA(INDEX('[2022 - School - Real Estate.xls]Real Estate'!$H$2:$M$7000,MATCH($C$12,'[2022 - School - Real Estate.xls]Real Estate'!$U$2:$U$7000,0),))/2, INDEX('[2022 - School - Real Estate.xls]Real Estate'!$H$2:$M$7000,MATCH($C$12,'[2022 - School - Real Estate.xls]Real Estate'!$U$2:$U$7000,0),2*ROWS($C$32:C32)-1),""),"")	=IFERROR(IF(ROWS($D$32:D32)<=COUNTA(INDEX('[2022 - School - Real Estate.xls]Real Estate'!$H$2:$M$7000,MATCH($C$12,'[2022 - School - Real Estate.xls]Real Estate'!$U$2:$U$7000,0),))/2, INDEX('[2022 - School - Real Estate.xls]Real Estate'!$H$2:$M$7000,MATCH($C$12,'[2022 - School - Real Estate.xls]Real Estate'!$U$2:$U$7000,0),2*ROWS($D$32:D32)),""),"" )	FACE
33		PAYMENT #2	=IFERROR(IF(ROWS($C$32:C33)<=COUNTA(INDEX('[2022 - School - Real Estate.xls]Real Estate'!$H$2:$M$7000,MATCH($C$12,'[2022 - School - Real Estate.xls]Real Estate'!$U$2:$U$7000,0),))/2, INDEX('[2022 - School - Real Estate.xls]Real Estate'!$H$2:$M$7000,MATCH($C$12,'[2022 - School - Real Estate.xls]Real Estate'!$U$2:$U$7000,0),2*ROWS($C$32:C33)-1),""),"")	=IFERROR(IF(ROWS($D$32:D33)<=COUNTA(INDEX('[2022 - School - Real Estate.xls]Real Estate'!$H$2:$M$7000,MATCH($C$12,'[2022 - School - Real Estate.xls]Real Estate'!$U$2:$U$7000,0),))/2, INDEX('[2022 - School - Real Estate.xls]Real Estate'!$H$2:$M$7000,MATCH($C$12,'[2022 - School - Real Estate.xls]Real Estate'!$U$2:$U$7000,0),2*ROWS($D$32:D33)),""),"" )	FALSE
34		PAYMENT #3	=IFERROR(IF(ROWS($C$32:C34)<=COUNTA(INDEX('[2022 - School - Real Estate.xls]Real Estate'!$H$2:$M$7000,MATCH($C$12,'[2022 - School - Real Estate.xls]Real Estate'!$U$2:$U$7000,0),))/2, INDEX('[2022 - School - Real Estate.xls]Real Estate'!$H$2:$M$7000,MATCH($C$12,'[2022 - School - Real Estate.xls]Real Estate'!$U$2:$U$7000,0),2*ROWS($C$32:C34)-1),""),"")	=IFERROR(IF(ROWS($D$32:D34)<=COUNTA(INDEX('[2022 - School - Real Estate.xls]Real Estate'!$H$2:$M$7000,MATCH($C$12,'[2022 - School - Real Estate.xls]Real Estate'!$U$2:$U$7000,0),))/2, INDEX('[2022 - School - Real Estate.xls]Real Estate'!$H$2:$M$7000,MATCH($C$12,'[2022 - School - Real Estate.xls]Real Estate'!$U$2:$U$7000,0),2*ROWS($D$32:D34)),""),"" )	FALSE
35
36	COUNTY/LOCAL 2021		3/1-4/30	5/1-6/30	7/1-12/31
37			Discount (-2%)	Face:	Penalty (+10%)
38		PAID	$157.83	$161.06	$177.18
39	Date Paid:	7/16/2021		Assessed Value:	1,810
40
41
42	SCHOOL 2021		July/Aug	Sept/Oct	Nov/Dec
43			Discount (-2%)	Face:	Penalty (+10%)
44		PAID	$64.07	$65.38	$71.92
45	Date Paid:	10/29/2021		HomeStead	Assessed Value
46				NO	1,810
47		PARTIALS	DATE	$0.00	<- SHORT IN FACE
48		PAYMENT #1	09/15/2021	$21.79	FACE
49		PAYMENT #2	10/18/2021	$21.79	FACE
50		PAYMENT #3	10/29/2021	$21.79	FACE
Tax Cert Form 2022-2021 (2)

Cell Formulas
Range	Formula
C22	C22	=INDEX('[RLE_County Local 2022.xls]Real Estate'!$H$2:$P$7000,MATCH($C$12,'[RLE_County Local 2022.xls]Real Estate'!$P$2:$P$7000,0),1)
D22	D22	=INDEX('[RLE_County Local 2022.xls]Real Estate'!$H$2:$P$7000,MATCH($C$12,'[RLE_County Local 2022.xls]Real Estate'!$P$2:$P$7000,0),2)
E22	E22	=INDEX('[RLE_County Local 2022.xls]Real Estate'!$H$2:$P$7000,MATCH($C$12,'[RLE_County Local 2022.xls]Real Estate'!$P$2:$P$7000,0),3)
B21	B21	=INDEX('[RLE_County Local 2022.xls]Real Estate'!$B$2:$P$7000,MATCH(C12,'[RLE_County Local 2022.xls]Real Estate'!$P$2:$P$7000,0),1)
B22,B38	B22	=IF(B23=" ", "UNPAID", "PAID")
B23	B23	=INDEX('[RLE_County Local 2022.xls]Real Estate'!$C$2:$P$7000,MATCH($C$12,'[RLE_County Local 2022.xls]Real Estate'!$P$2:$P$7000,0),1)
E24	E24	=INDEX('[RLE_County Local 2022.xls]Real Estate'!$N$2:$P$7000,MATCH(C12,'[RLE_County Local 2022.xls]Real Estate'!$P$2:$P$7000,0),1)
D31,D47	D31	=IF(D28<=SUM(D32,D33,D34),0,IF(SUM(D28,-N(D32),-N(D33),-N(D34))<=0.02,0,IF(D28>=SUM(D32,D33,D34),SUM(D28,-N(D32),-N(D33),-N(D34)),"help")))
E32,E48	E32	=IF(C32="","", "FACE")
E33,E49	E33	=IF(C33="","",IF(D33=0,"UNPAID",IF(D33<=D32,"FACE",IF(D32>D33,"PENALTY"))))
E34,E50	E34	=IF(C34="","",IF(D34=0,"UNPAID",IF(D34<=D32,"FACE",IF(D32>D34,"PENALTY"))))
C38	C38	=INDEX('C&L Real Estate'!$H$2:$P$7000,MATCH($C$12,'C&L Real Estate'!$O$2:$O$7000,0),1)
D38	D38	=INDEX('C&L Real Estate'!$I$2:$P$7000,MATCH($C$12,'C&L Real Estate'!$O$2:$O$7000,0),1)
B39	B39	=INDEX('C&L Real Estate'!$C$2:$P$7000,MATCH($C$12,'C&L Real Estate'!$O$2:$O$7000,0),1)
E38	E38	=INDEX('C&L Real Estate'!$J$2:$P$7000,MATCH($C$12,'C&L Real Estate'!$O$2:$O$7000,0),1)
E39	E39	=INDEX('C&L Real Estate'!$N$2:$P$7000,MATCH($C$12,'C&L Real Estate'!$O$2:$O$7000,0),1)
C44	C44	=INDEX('SK Real Estate 2'!$U$2:$AK$7000,MATCH($C$12,'SK Real Estate 2'!$U$2:$U$7000,0),11)
D44	D44	=INDEX('SK Real Estate 2'!$U$2:$AK$7000,MATCH($C$12,'SK Real Estate 2'!$U$2:$U$7000,0),12)
E44	E44	=INDEX('SK Real Estate 2'!$U$2:$AK$7000,MATCH($C$12,'SK Real Estate 2'!$U$2:$U$7000,0),13)
B44	B44	=IF(B45="","UNPAID",IF(B45="EXONERATED","PER COUNTY",IF(B45="Tax Claims", "SHORT", "PAID")))
B45	B45	=IF(D47<=0,C50,IF(D44>D47,"Tax Claims",INDEX('SK Real Estate 2'!$C$2:$U$7000,MATCH($C$12,'SK Real Estate 2'!$U$2:$U$7000,0),1)))
E46	E46	=INDEX('SK Real Estate 2'!$T$2:$U$7000,MATCH($C$12,'SK Real Estate 2'!$U$2:$U$7000,0),1)
D46	D46	=INDEX('SK Real Estate 2'!$U$2:$AI$7000,MATCH($C$12,'SK Real Estate 2'!$U$2:$U$7000,0),15)
C48:C50	C48	=IFERROR(IF(ROWS(C$48:C48)<=COUNTA(INDEX('SK Real Estate 2'!$H$2:$M$7000,MATCH($C$12,'SK Real Estate 2'!$U$2:$U$7000,0),))/2, INDEX('SK Real Estate 2'!$H$2:$M$7000,MATCH($C$12,'SK Real Estate 2'!$U$2:$U$7000,0),2*ROWS(C$48:C48)-1),""),"")
D48:D50	D48	=IFERROR(IF(ROWS(D$48:D48)<=COUNTA(INDEX('SK Real Estate 2'!$H$2:$M$7000,MATCH($C$12,'SK Real Estate 2'!$U$2:$U$7000,0),))/2, INDEX('SK Real Estate 2'!$H$2:$M$7000,MATCH($C$12,'SK Real Estate 2'!$U$2:$U$7000,0),2*ROWS(D$48:D48)),""),"" )

hope it shows it right!