Extract data between two sets of dates in two columns.

[Kannie]

Hallo everyone.

Thanks in advance for any assistance you can provide.

I need to create a report and extract only the rows between the Build Start Date-H1, Build End Date-H2 in column A, Dismantle Start Date-J1 and Dismantle End Date-J2 in column B. Some of the records will only be applicable to the Build date in column A or Dismantle date in Column B and some will be a combination of both as I highlighted them in yellow based on my input dates in H1, .There will also be blank cells in column B. The certificate column C contains unique values. How would I construct the formulas to achieve this?

	[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]A[/COLOR]​	[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]B[/COLOR]​	[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]C[/COLOR]​	[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]D[/COLOR]​	[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]E[/COLOR]​	[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]F[/COLOR]​	[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]G[/COLOR]​	[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]H[/COLOR]​	[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]I[/COLOR]​	[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]J[/COLOR] ​
[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]1[/COLOR]​	Build Date​	Dismantle date​	Certificate​	Build Cost​	Dismantle Cost​		Build Start Date	2018-08-01​	Dismantle Start Date	2018-08-01​
[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]2[/COLOR]​	2018-04-15​	2018-04-21​	8100​	R 1 000.00​	R 5 000.00​		Build End Date	2018-08-17​	Dismantle End Date	2018-08-17​
[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]3[/COLOR]​	2018-04-18​	2018-04-22​	8101​	R 1 100.00​	R 5 100.00​
[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]4[/COLOR]​	2018-04-19​	2018-04-23​	8102​	R 1 200.00​	R 5 200.00​
[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]5[/COLOR]​	2018-04-20​	2018-04-24​	8103​	R 1 300.00​	R 5 300.00​
[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]6[/COLOR]​	2018-05-02​	2018-08-01​	8104​	R 1 400.00​	R 5 400.00​
[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]7[/COLOR]​	2018-05-03​	2018-08-02​	8105​	R 1 500.00​	R 5 500.00​
[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]8[/COLOR]​	2018-05-04​	2018-08-03​	8106​	R 1 600.00​	R 5 600.00​
[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]9[/COLOR]​	2018-05-05​	2018-08-04​	8107​	R 1 700.00​	R 5 700.00​
[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]10[/COLOR]​	2018-05-06​	2018-08-05​	8108​	R 1 800.00​	R 5 800.00​
[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]11[/COLOR]​	2018-08-01​	2018-08-06​	8109​	R 1 900.00​	R 5 900.00​
[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]12[/COLOR]​	2018-08-02​	2018-08-07​	8110​	R 2 000.00​	R 6 000.00​
[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]13[/COLOR]​	2018-08-03​	2018-08-08​	8111​	R 2 100.00​	R 6 100.00​
[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]14[/COLOR]​	2018-08-04​	2018-08-09​	8112​	R 2 200.00​	R 6 200.00​
[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]15[/COLOR]​	2018-08-05​	2018-08-10​	8113​	R 2 300.00​	R 6 300.00​
[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]16[/COLOR]​	2018-08-12​		8114​	R 2 400.00​	R 6 400.00​
[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]17[/COLOR]​	2018-08-13​		8115​	R 2 500.00​	R 6 500.00​
[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]18[/COLOR]​	2018-08-14​		8116​	R 2 600.00​	R 6 600.00​
[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]19[/COLOR]​	2018-08-15​		8117​	R 2 700.00​	R 6 700.00​
[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]20[/COLOR]​	2018-08-16​		8118​	R 2 800.00​	R 6 800.00​
[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]21[/COLOR]​	2018-08-17​		8119​	R 2 900.00​	R 6 900.00​
[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]22[/COLOR]​	2018-08-18​		8119​	R 2 900.00​	R 6 900.00​
[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]23[/COLOR]​	2018-08-19​		8119​	R 2 900.00​	R 6 900.00​
[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]24[/COLOR]​	2018-08-20​		8119​	R 2 900.00​	R 6 900.00​
[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]25[/COLOR]​	2018-08-21​		8119​	R 2 900.00​	R 6 900.00​
[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]26[/COLOR]​	2018-08-22​		8119​	R 2 900.00​	R 6 900.00​

<tbody>
</tbody>

 

[RasGhul]

	A	B	C	D	E	F	G	H	I	J	K	L
1	Build Date	Dismantle date	Certificate	Build Cost	Build Cost1	Dismantle Cost	Dismantle Cost1		Build Start Date	01-08-18	Dismantle Start Date	01-08-18
2	15-04-18	21-04-18	8100	R 1 000.00	$1,000.00	R 5 000.00	$5,000.00		Build End Date	17-08-18	Dismantle End Date	17-08-18
3	18-04-18	22-04-18	8101	R 1 100.00	$1,100.00	R 5 100.00	$5,100.00
4	19-04-18	23-04-18	8102	R 1 200.00	$1,200.00	R 5 200.00	$5,200.00
5	20-04-18	24-04-18	8103	R 1 300.00	$1,300.00	R 5 300.00	$5,300.00
6	02-05-18	01-08-18	8104	R 1 400.00	$1,400.00	R 5 400.00	$5,400.00		Build Cost	$26,400.00
7	03-05-18	02-08-18	8105	R 1 500.00	$1,500.00	R 5 500.00	$5,500.00		Dismantle Cost	$58,500.00
8	04-05-18	03-08-18	8106	R 1 600.00	$1,600.00	R 5 600.00	$5,600.00
9	05-05-18	04-08-18	8107	R 1 700.00	$1,700.00	R 5 700.00	$5,700.00
10	06-05-18	05-08-18	8108	R 1 800.00	$1,800.00	R 5 800.00	$5,800.00		TOTAL	$84,900.00
11	01-08-18	06-08-18	8109	R 1 900.00	$1,900.00	R 5 900.00	$5,900.00
12	02-08-18	07-08-18	8110	R 2 000.00	$2,000.00	R 6 000.00	$6,000.00
13	03-08-18	08-08-18	8111	R 2 100.00	$2,100.00	R 6 100.00	$6,100.00
14	04-08-18	09-08-18	8112	R 2 200.00	$2,200.00	R 6 200.00	$6,200.00
15	05-08-18	10-08-18	8113	R 2 300.00	$2,300.00	R 6 300.00	$6,300.00
16	12-08-18		8114	R 2 400.00	$2,400.00	R 6 400.00	$6,400.00
17	13-08-18		8115	R 2 500.00	$2,500.00	R 6 500.00	$6,500.00
18	14-08-18		8116	R 2 600.00	$2,600.00	R 6 600.00	$6,600.00
19	15-08-18		8117	R 2 700.00	$2,700.00	R 6 700.00	$6,700.00
20	16-08-18		8118	R 2 800.00	$2,800.00	R 6 800.00	$6,800.00
21	17-08-18		8119	R 2 900.00	$2,900.00	R 6 900.00	$6,900.00
22	18-08-18		8119	R 2 900.00	$2,900.00	R 6 900.00	$6,900.00
23	19-08-18		8119	R 2 900.00	$2,900.00	R 6 900.00	$6,900.00
24	20-08-18		8119	R 2 900.00	$2,900.00	R 6 900.00	$6,900.00
25	21-08-18		8119	R 2 900.00	$2,900.00	R 6 900.00	$6,900.00
26	22-08-18		8119	R 2 900.00	$2,900.00	R 6 900.00	$6,900.00

<tbody>
</tbody>

Sheet1​

Note that I added Column E & G, to convert your data into numbers for sum;

Build Cost

=SUMIFS($E$2:$E$26,$A$2:$A$26,">="&$J$1,$A$2:$A$26,"<="&$J$2)

Dismantle Cost

=SUMIFS($G$2:$G$26,$B$2:$B$26,">="&$L$1,$B$2:$B$26,"<="&$L$2)

Column E Drag Down

=VALUE(SUBSTITUTE(SUBSTITUTE(D2,"R ","")," ",""))

Column G Drag Down

=VALUE(SUBSTITUTE(SUBSTITUTE(F2,"R ","")," ",""))

 

[Kannie]

Thanks for the reply RasGhul

Your formulas are working but I don't want to sum the values between the criteria range in Column A and B. I want to extract all the records that fall within that criteria range to another sheet in the same workbook. The records I want extracted falls in this range A6:E21 from the table in my post. Would that be possible?

 

[RasGhul]

Argh extract sorry,

Don't forget you will need to change your Sheet references if you have named them;

Book1
	A	B	C
1	Build Date	Certificate	Build Cost
2	01-08-18	8109	R 1 900.00
3	02-08-18	8110	R 2 000.00
4	03-08-18	8111	R 2 100.00
5	04-08-18	8112	R 2 200.00
6	05-08-18	8113	R 2 300.00
7	12-08-18	8114	R 2 400.00
8	13-08-18	8115	R 2 500.00
9	14-08-18	8116	R 2 600.00
10	15-08-18	8117	R 2 700.00
11	16-08-18	8118	R 2 800.00
12	17-08-18	8119	R 2 900.00
Sheet2

Cell Formulas
Range	Formula
A2	{=IFERROR(INDEX(Sheet1!A$2:A$26,SMALL(IF(Sheet1!A$2:A$26>=Sheet1!$H$1,IF(Sheet1!A$2:A$26<=Sheet1!$H$2,ROW(Sheet1!$A$2:$A$26)-ROW(Sheet1!$A$2)+1)),ROWS(Sheet2!A$2:A2))),"")}
A3	{=IFERROR(INDEX(Sheet1!A$2:A$26,SMALL(IF(Sheet1!A$2:A$26>=Sheet1!$H$1,IF(Sheet1!A$2:A$26<=Sheet1!$H$2,ROW(Sheet1!$A$2:$A$26)-ROW(Sheet1!$A$2)+1)),ROWS(Sheet2!A$2:A3))),"")}
A4	{=IFERROR(INDEX(Sheet1!A$2:A$26,SMALL(IF(Sheet1!A$2:A$26>=Sheet1!$H$1,IF(Sheet1!A$2:A$26<=Sheet1!$H$2,ROW(Sheet1!$A$2:$A$26)-ROW(Sheet1!$A$2)+1)),ROWS(Sheet2!A$2:A4))),"")}
A5	{=IFERROR(INDEX(Sheet1!A$2:A$26,SMALL(IF(Sheet1!A$2:A$26>=Sheet1!$H$1,IF(Sheet1!A$2:A$26<=Sheet1!$H$2,ROW(Sheet1!$A$2:$A$26)-ROW(Sheet1!$A$2)+1)),ROWS(Sheet2!A$2:A5))),"")}
A6	{=IFERROR(INDEX(Sheet1!A$2:A$26,SMALL(IF(Sheet1!A$2:A$26>=Sheet1!$H$1,IF(Sheet1!A$2:A$26<=Sheet1!$H$2,ROW(Sheet1!$A$2:$A$26)-ROW(Sheet1!$A$2)+1)),ROWS(Sheet2!A$2:A6))),"")}
A7	{=IFERROR(INDEX(Sheet1!A$2:A$26,SMALL(IF(Sheet1!A$2:A$26>=Sheet1!$H$1,IF(Sheet1!A$2:A$26<=Sheet1!$H$2,ROW(Sheet1!$A$2:$A$26)-ROW(Sheet1!$A$2)+1)),ROWS(Sheet2!A$2:A7))),"")}
A8	{=IFERROR(INDEX(Sheet1!A$2:A$26,SMALL(IF(Sheet1!A$2:A$26>=Sheet1!$H$1,IF(Sheet1!A$2:A$26<=Sheet1!$H$2,ROW(Sheet1!$A$2:$A$26)-ROW(Sheet1!$A$2)+1)),ROWS(Sheet2!A$2:A8))),"")}
A9	{=IFERROR(INDEX(Sheet1!A$2:A$26,SMALL(IF(Sheet1!A$2:A$26>=Sheet1!$H$1,IF(Sheet1!A$2:A$26<=Sheet1!$H$2,ROW(Sheet1!$A$2:$A$26)-ROW(Sheet1!$A$2)+1)),ROWS(Sheet2!A$2:A9))),"")}
A10	{=IFERROR(INDEX(Sheet1!A$2:A$26,SMALL(IF(Sheet1!A$2:A$26>=Sheet1!$H$1,IF(Sheet1!A$2:A$26<=Sheet1!$H$2,ROW(Sheet1!$A$2:$A$26)-ROW(Sheet1!$A$2)+1)),ROWS(Sheet2!A$2:A10))),"")}
A11	{=IFERROR(INDEX(Sheet1!A$2:A$26,SMALL(IF(Sheet1!A$2:A$26>=Sheet1!$H$1,IF(Sheet1!A$2:A$26<=Sheet1!$H$2,ROW(Sheet1!$A$2:$A$26)-ROW(Sheet1!$A$2)+1)),ROWS(Sheet2!A$2:A11))),"")}
A12	{=IFERROR(INDEX(Sheet1!A$2:A$26,SMALL(IF(Sheet1!A$2:A$26>=Sheet1!$H$1,IF(Sheet1!A$2:A$26<=Sheet1!$H$2,ROW(Sheet1!$A$2:$A$26)-ROW(Sheet1!$A$2)+1)),ROWS(Sheet2!A$2:A12))),"")}
B2	{=IFERROR(INDEX(Sheet1!C$2:C$26,SMALL(IF(Sheet1!A$2:A$26>=Sheet1!$H$1,IF(Sheet1!A$2:A$26<=Sheet1!$H$2,ROW(Sheet1!$A$2:$A$26)-ROW(Sheet1!$A$2)+1)),ROWS(Sheet2!A$2:A2))),"")}
B3	{=IFERROR(INDEX(Sheet1!C$2:C$26,SMALL(IF(Sheet1!A$2:A$26>=Sheet1!$H$1,IF(Sheet1!A$2:A$26<=Sheet1!$H$2,ROW(Sheet1!$A$2:$A$26)-ROW(Sheet1!$A$2)+1)),ROWS(Sheet2!A$2:A3))),"")}
B4	{=IFERROR(INDEX(Sheet1!C$2:C$26,SMALL(IF(Sheet1!A$2:A$26>=Sheet1!$H$1,IF(Sheet1!A$2:A$26<=Sheet1!$H$2,ROW(Sheet1!$A$2:$A$26)-ROW(Sheet1!$A$2)+1)),ROWS(Sheet2!A$2:A4))),"")}
B5	{=IFERROR(INDEX(Sheet1!C$2:C$26,SMALL(IF(Sheet1!A$2:A$26>=Sheet1!$H$1,IF(Sheet1!A$2:A$26<=Sheet1!$H$2,ROW(Sheet1!$A$2:$A$26)-ROW(Sheet1!$A$2)+1)),ROWS(Sheet2!A$2:A5))),"")}
B6	{=IFERROR(INDEX(Sheet1!C$2:C$26,SMALL(IF(Sheet1!A$2:A$26>=Sheet1!$H$1,IF(Sheet1!A$2:A$26<=Sheet1!$H$2,ROW(Sheet1!$A$2:$A$26)-ROW(Sheet1!$A$2)+1)),ROWS(Sheet2!A$2:A6))),"")}
B7	{=IFERROR(INDEX(Sheet1!C$2:C$26,SMALL(IF(Sheet1!A$2:A$26>=Sheet1!$H$1,IF(Sheet1!A$2:A$26<=Sheet1!$H$2,ROW(Sheet1!$A$2:$A$26)-ROW(Sheet1!$A$2)+1)),ROWS(Sheet2!A$2:A7))),"")}
B8	{=IFERROR(INDEX(Sheet1!C$2:C$26,SMALL(IF(Sheet1!A$2:A$26>=Sheet1!$H$1,IF(Sheet1!A$2:A$26<=Sheet1!$H$2,ROW(Sheet1!$A$2:$A$26)-ROW(Sheet1!$A$2)+1)),ROWS(Sheet2!A$2:A8))),"")}
B9	{=IFERROR(INDEX(Sheet1!C$2:C$26,SMALL(IF(Sheet1!A$2:A$26>=Sheet1!$H$1,IF(Sheet1!A$2:A$26<=Sheet1!$H$2,ROW(Sheet1!$A$2:$A$26)-ROW(Sheet1!$A$2)+1)),ROWS(Sheet2!A$2:A9))),"")}
B10	{=IFERROR(INDEX(Sheet1!C$2:C$26,SMALL(IF(Sheet1!A$2:A$26>=Sheet1!$H$1,IF(Sheet1!A$2:A$26<=Sheet1!$H$2,ROW(Sheet1!$A$2:$A$26)-ROW(Sheet1!$A$2)+1)),ROWS(Sheet2!A$2:A10))),"")}
B11	{=IFERROR(INDEX(Sheet1!C$2:C$26,SMALL(IF(Sheet1!A$2:A$26>=Sheet1!$H$1,IF(Sheet1!A$2:A$26<=Sheet1!$H$2,ROW(Sheet1!$A$2:$A$26)-ROW(Sheet1!$A$2)+1)),ROWS(Sheet2!A$2:A11))),"")}
B12	{=IFERROR(INDEX(Sheet1!C$2:C$26,SMALL(IF(Sheet1!A$2:A$26>=Sheet1!$H$1,IF(Sheet1!A$2:A$26<=Sheet1!$H$2,ROW(Sheet1!$A$2:$A$26)-ROW(Sheet1!$A$2)+1)),ROWS(Sheet2!A$2:A12))),"")}
C2	{=IFERROR(INDEX(Sheet1!D$2:D$26,SMALL(IF(Sheet1!A$2:A$26>=Sheet1!$H$1,IF(Sheet1!A$2:A$26<=Sheet1!$H$2,ROW(Sheet1!$A$2:$A$26)-ROW(Sheet1!$A$2)+1)),ROWS(Sheet2!A$2:A2))),"")}
C3	{=IFERROR(INDEX(Sheet1!D$2:D$26,SMALL(IF(Sheet1!A$2:A$26>=Sheet1!$H$1,IF(Sheet1!A$2:A$26<=Sheet1!$H$2,ROW(Sheet1!$A$2:$A$26)-ROW(Sheet1!$A$2)+1)),ROWS(Sheet2!A$2:A3))),"")}
C4	{=IFERROR(INDEX(Sheet1!D$2:D$26,SMALL(IF(Sheet1!A$2:A$26>=Sheet1!$H$1,IF(Sheet1!A$2:A$26<=Sheet1!$H$2,ROW(Sheet1!$A$2:$A$26)-ROW(Sheet1!$A$2)+1)),ROWS(Sheet2!A$2:A4))),"")}
C5	{=IFERROR(INDEX(Sheet1!D$2:D$26,SMALL(IF(Sheet1!A$2:A$26>=Sheet1!$H$1,IF(Sheet1!A$2:A$26<=Sheet1!$H$2,ROW(Sheet1!$A$2:$A$26)-ROW(Sheet1!$A$2)+1)),ROWS(Sheet2!A$2:A5))),"")}
C6	{=IFERROR(INDEX(Sheet1!D$2:D$26,SMALL(IF(Sheet1!A$2:A$26>=Sheet1!$H$1,IF(Sheet1!A$2:A$26<=Sheet1!$H$2,ROW(Sheet1!$A$2:$A$26)-ROW(Sheet1!$A$2)+1)),ROWS(Sheet2!A$2:A6))),"")}
C7	{=IFERROR(INDEX(Sheet1!D$2:D$26,SMALL(IF(Sheet1!A$2:A$26>=Sheet1!$H$1,IF(Sheet1!A$2:A$26<=Sheet1!$H$2,ROW(Sheet1!$A$2:$A$26)-ROW(Sheet1!$A$2)+1)),ROWS(Sheet2!A$2:A7))),"")}
C8	{=IFERROR(INDEX(Sheet1!D$2:D$26,SMALL(IF(Sheet1!A$2:A$26>=Sheet1!$H$1,IF(Sheet1!A$2:A$26<=Sheet1!$H$2,ROW(Sheet1!$A$2:$A$26)-ROW(Sheet1!$A$2)+1)),ROWS(Sheet2!A$2:A8))),"")}
C9	{=IFERROR(INDEX(Sheet1!D$2:D$26,SMALL(IF(Sheet1!A$2:A$26>=Sheet1!$H$1,IF(Sheet1!A$2:A$26<=Sheet1!$H$2,ROW(Sheet1!$A$2:$A$26)-ROW(Sheet1!$A$2)+1)),ROWS(Sheet2!A$2:A9))),"")}
C10	{=IFERROR(INDEX(Sheet1!D$2:D$26,SMALL(IF(Sheet1!A$2:A$26>=Sheet1!$H$1,IF(Sheet1!A$2:A$26<=Sheet1!$H$2,ROW(Sheet1!$A$2:$A$26)-ROW(Sheet1!$A$2)+1)),ROWS(Sheet2!A$2:A10))),"")}
C11	{=IFERROR(INDEX(Sheet1!D$2:D$26,SMALL(IF(Sheet1!A$2:A$26>=Sheet1!$H$1,IF(Sheet1!A$2:A$26<=Sheet1!$H$2,ROW(Sheet1!$A$2:$A$26)-ROW(Sheet1!$A$2)+1)),ROWS(Sheet2!A$2:A11))),"")}
C12	{=IFERROR(INDEX(Sheet1!D$2:D$26,SMALL(IF(Sheet1!A$2:A$26>=Sheet1!$H$1,IF(Sheet1!A$2:A$26<=Sheet1!$H$2,ROW(Sheet1!$A$2:$A$26)-ROW(Sheet1!$A$2)+1)),ROWS(Sheet2!A$2:A12))),"")}
Press CTRL+SHIFT+ENTER to enter array formulas.

Book1
	A	B	C
14	Dismantle date	Certificate	Dismantle Cost
15	01-08-18	8104	R 5 400.00
16	02-08-18	8105	R 5 500.00
17	03-08-18	8106	R 5 600.00
18	04-08-18	8107	R 5 700.00
19	05-08-18	8108	R 5 800.00
20	06-08-18	8109	R 5 900.00
21	07-08-18	8110	R 6 000.00
22	08-08-18	8111	R 6 100.00
23	09-08-18	8112	R 6 200.00
24	10-08-18	8113	R 6 300.00
Sheet2

Cell Formulas
Range	Formula
A15	{=IFERROR(INDEX(Sheet1!B$2:B$26,SMALL(IF(Sheet1!B$2:B$26>=Sheet1!$H$1,IF(Sheet1!B$2:B$26<=Sheet1!$H$2,ROW(Sheet1!B$2:B$26)-ROW(Sheet1!$B$2)+1)),ROWS(Sheet2!$A$15:A15))),"")}
A16	{=IFERROR(INDEX(Sheet1!B$2:B$26,SMALL(IF(Sheet1!B$2:B$26>=Sheet1!$H$1,IF(Sheet1!B$2:B$26<=Sheet1!$H$2,ROW(Sheet1!B$2:B$26)-ROW(Sheet1!$B$2)+1)),ROWS(Sheet2!$A$15:A16))),"")}
A17	{=IFERROR(INDEX(Sheet1!B$2:B$26,SMALL(IF(Sheet1!B$2:B$26>=Sheet1!$H$1,IF(Sheet1!B$2:B$26<=Sheet1!$H$2,ROW(Sheet1!B$2:B$26)-ROW(Sheet1!$B$2)+1)),ROWS(Sheet2!$A$15:A17))),"")}
A18	{=IFERROR(INDEX(Sheet1!B$2:B$26,SMALL(IF(Sheet1!B$2:B$26>=Sheet1!$H$1,IF(Sheet1!B$2:B$26<=Sheet1!$H$2,ROW(Sheet1!B$2:B$26)-ROW(Sheet1!$B$2)+1)),ROWS(Sheet2!$A$15:A18))),"")}
A19	{=IFERROR(INDEX(Sheet1!B$2:B$26,SMALL(IF(Sheet1!B$2:B$26>=Sheet1!$H$1,IF(Sheet1!B$2:B$26<=Sheet1!$H$2,ROW(Sheet1!B$2:B$26)-ROW(Sheet1!$B$2)+1)),ROWS(Sheet2!$A$15:A19))),"")}
A20	{=IFERROR(INDEX(Sheet1!B$2:B$26,SMALL(IF(Sheet1!B$2:B$26>=Sheet1!$H$1,IF(Sheet1!B$2:B$26<=Sheet1!$H$2,ROW(Sheet1!B$2:B$26)-ROW(Sheet1!$B$2)+1)),ROWS(Sheet2!$A$15:A20))),"")}
A21	{=IFERROR(INDEX(Sheet1!B$2:B$26,SMALL(IF(Sheet1!B$2:B$26>=Sheet1!$H$1,IF(Sheet1!B$2:B$26<=Sheet1!$H$2,ROW(Sheet1!B$2:B$26)-ROW(Sheet1!$B$2)+1)),ROWS(Sheet2!$A$15:A21))),"")}
A22	{=IFERROR(INDEX(Sheet1!B$2:B$26,SMALL(IF(Sheet1!B$2:B$26>=Sheet1!$H$1,IF(Sheet1!B$2:B$26<=Sheet1!$H$2,ROW(Sheet1!B$2:B$26)-ROW(Sheet1!$B$2)+1)),ROWS(Sheet2!$A$15:A22))),"")}
A23	{=IFERROR(INDEX(Sheet1!B$2:B$26,SMALL(IF(Sheet1!B$2:B$26>=Sheet1!$H$1,IF(Sheet1!B$2:B$26<=Sheet1!$H$2,ROW(Sheet1!B$2:B$26)-ROW(Sheet1!$B$2)+1)),ROWS(Sheet2!$A$15:A23))),"")}
A24	{=IFERROR(INDEX(Sheet1!B$2:B$26,SMALL(IF(Sheet1!B$2:B$26>=Sheet1!$H$1,IF(Sheet1!B$2:B$26<=Sheet1!$H$2,ROW(Sheet1!B$2:B$26)-ROW(Sheet1!$B$2)+1)),ROWS(Sheet2!$A$15:A24))),"")}
B15	{=IFERROR(INDEX(Sheet1!C$2:C$26,SMALL(IF(Sheet1!B$2:B$26>=Sheet1!$H$1,IF(Sheet1!B$2:B$26<=Sheet1!$H$2,ROW(Sheet1!B$2:B$26)-ROW(Sheet1!$B$2)+1)),ROWS(Sheet2!$A$15:A15))),"")}
B16	{=IFERROR(INDEX(Sheet1!C$2:C$26,SMALL(IF(Sheet1!B$2:B$26>=Sheet1!$H$1,IF(Sheet1!B$2:B$26<=Sheet1!$H$2,ROW(Sheet1!B$2:B$26)-ROW(Sheet1!$B$2)+1)),ROWS(Sheet2!$A$15:A16))),"")}
B17	{=IFERROR(INDEX(Sheet1!C$2:C$26,SMALL(IF(Sheet1!B$2:B$26>=Sheet1!$H$1,IF(Sheet1!B$2:B$26<=Sheet1!$H$2,ROW(Sheet1!B$2:B$26)-ROW(Sheet1!$B$2)+1)),ROWS(Sheet2!$A$15:A17))),"")}
B18	{=IFERROR(INDEX(Sheet1!C$2:C$26,SMALL(IF(Sheet1!B$2:B$26>=Sheet1!$H$1,IF(Sheet1!B$2:B$26<=Sheet1!$H$2,ROW(Sheet1!B$2:B$26)-ROW(Sheet1!$B$2)+1)),ROWS(Sheet2!$A$15:A18))),"")}
B19	{=IFERROR(INDEX(Sheet1!C$2:C$26,SMALL(IF(Sheet1!B$2:B$26>=Sheet1!$H$1,IF(Sheet1!B$2:B$26<=Sheet1!$H$2,ROW(Sheet1!B$2:B$26)-ROW(Sheet1!$B$2)+1)),ROWS(Sheet2!$A$15:A19))),"")}
B20	{=IFERROR(INDEX(Sheet1!C$2:C$26,SMALL(IF(Sheet1!B$2:B$26>=Sheet1!$H$1,IF(Sheet1!B$2:B$26<=Sheet1!$H$2,ROW(Sheet1!B$2:B$26)-ROW(Sheet1!$B$2)+1)),ROWS(Sheet2!$A$15:A20))),"")}
B21	{=IFERROR(INDEX(Sheet1!C$2:C$26,SMALL(IF(Sheet1!B$2:B$26>=Sheet1!$H$1,IF(Sheet1!B$2:B$26<=Sheet1!$H$2,ROW(Sheet1!B$2:B$26)-ROW(Sheet1!$B$2)+1)),ROWS(Sheet2!$A$15:A21))),"")}
B22	{=IFERROR(INDEX(Sheet1!C$2:C$26,SMALL(IF(Sheet1!B$2:B$26>=Sheet1!$H$1,IF(Sheet1!B$2:B$26<=Sheet1!$H$2,ROW(Sheet1!B$2:B$26)-ROW(Sheet1!$B$2)+1)),ROWS(Sheet2!$A$15:A22))),"")}
B23	{=IFERROR(INDEX(Sheet1!C$2:C$26,SMALL(IF(Sheet1!B$2:B$26>=Sheet1!$H$1,IF(Sheet1!B$2:B$26<=Sheet1!$H$2,ROW(Sheet1!B$2:B$26)-ROW(Sheet1!$B$2)+1)),ROWS(Sheet2!$A$15:A23))),"")}
B24	{=IFERROR(INDEX(Sheet1!C$2:C$26,SMALL(IF(Sheet1!B$2:B$26>=Sheet1!$H$1,IF(Sheet1!B$2:B$26<=Sheet1!$H$2,ROW(Sheet1!B$2:B$26)-ROW(Sheet1!$B$2)+1)),ROWS(Sheet2!$A$15:A24))),"")}
C15	{=IFERROR(INDEX(Sheet1!E$2:E$26,SMALL(IF(Sheet1!B$2:B$26>=Sheet1!$H$1,IF(Sheet1!B$2:B$26<=Sheet1!$H$2,ROW(Sheet1!B$2:B$26)-ROW(Sheet1!$B$2)+1)),ROWS(Sheet2!$A$15:A15))),"")}
C16	{=IFERROR(INDEX(Sheet1!E$2:E$26,SMALL(IF(Sheet1!B$2:B$26>=Sheet1!$H$1,IF(Sheet1!B$2:B$26<=Sheet1!$H$2,ROW(Sheet1!B$2:B$26)-ROW(Sheet1!$B$2)+1)),ROWS(Sheet2!$A$15:A16))),"")}
C17	{=IFERROR(INDEX(Sheet1!E$2:E$26,SMALL(IF(Sheet1!B$2:B$26>=Sheet1!$H$1,IF(Sheet1!B$2:B$26<=Sheet1!$H$2,ROW(Sheet1!B$2:B$26)-ROW(Sheet1!$B$2)+1)),ROWS(Sheet2!$A$15:A17))),"")}
C18	{=IFERROR(INDEX(Sheet1!E$2:E$26,SMALL(IF(Sheet1!B$2:B$26>=Sheet1!$H$1,IF(Sheet1!B$2:B$26<=Sheet1!$H$2,ROW(Sheet1!B$2:B$26)-ROW(Sheet1!$B$2)+1)),ROWS(Sheet2!$A$15:A18))),"")}
C19	{=IFERROR(INDEX(Sheet1!E$2:E$26,SMALL(IF(Sheet1!B$2:B$26>=Sheet1!$H$1,IF(Sheet1!B$2:B$26<=Sheet1!$H$2,ROW(Sheet1!B$2:B$26)-ROW(Sheet1!$B$2)+1)),ROWS(Sheet2!$A$15:A19))),"")}
C20	{=IFERROR(INDEX(Sheet1!E$2:E$26,SMALL(IF(Sheet1!B$2:B$26>=Sheet1!$H$1,IF(Sheet1!B$2:B$26<=Sheet1!$H$2,ROW(Sheet1!B$2:B$26)-ROW(Sheet1!$B$2)+1)),ROWS(Sheet2!$A$15:A20))),"")}
C21	{=IFERROR(INDEX(Sheet1!E$2:E$26,SMALL(IF(Sheet1!B$2:B$26>=Sheet1!$H$1,IF(Sheet1!B$2:B$26<=Sheet1!$H$2,ROW(Sheet1!B$2:B$26)-ROW(Sheet1!$B$2)+1)),ROWS(Sheet2!$A$15:A21))),"")}
C22	{=IFERROR(INDEX(Sheet1!E$2:E$26,SMALL(IF(Sheet1!B$2:B$26>=Sheet1!$H$1,IF(Sheet1!B$2:B$26<=Sheet1!$H$2,ROW(Sheet1!B$2:B$26)-ROW(Sheet1!$B$2)+1)),ROWS(Sheet2!$A$15:A22))),"")}
C23	{=IFERROR(INDEX(Sheet1!E$2:E$26,SMALL(IF(Sheet1!B$2:B$26>=Sheet1!$H$1,IF(Sheet1!B$2:B$26<=Sheet1!$H$2,ROW(Sheet1!B$2:B$26)-ROW(Sheet1!$B$2)+1)),ROWS(Sheet2!$A$15:A23))),"")}
C24	{=IFERROR(INDEX(Sheet1!E$2:E$26,SMALL(IF(Sheet1!B$2:B$26>=Sheet1!$H$1,IF(Sheet1!B$2:B$26<=Sheet1!$H$2,ROW(Sheet1!B$2:B$26)-ROW(Sheet1!$B$2)+1)),ROWS(Sheet2!$A$15:A24))),"")}
Press CTRL+SHIFT+ENTER to enter array formulas.

 

[RasGhul]

Use the following for the Dismantle table, I noticed they were looking at the Build dates in error;

Book1
	A	B	C
14	Dismantle date	Certificate	Dismantle Cost
15	01-08-18	8104	R 5 400.00
16	02-08-18	8105	R 5 500.00
17	03-08-18	8106	R 5 600.00
18	04-08-18	8107	R 5 700.00
19	05-08-18	8108	R 5 800.00
20	06-08-18	8109	R 5 900.00
21	07-08-18	8110	R 6 000.00
22	08-08-18	8111	R 6 100.00
23	09-08-18	8112	R 6 200.00
24	10-08-18	8113	R 6 300.00
Sheet2

Cell Formulas
Range	Formula
A15	{=IFERROR(INDEX(Sheet1!B$2:B$26,SMALL(IF(Sheet1!B$2:B$26>=Sheet1!$J$1,IF(Sheet1!B$2:B$26<=Sheet1!$J$2,ROW(Sheet1!B$2:B$26)-ROW(Sheet1!$B$2)+1)),ROWS(Sheet2!$A$15:A15))),"")}
A16	{=IFERROR(INDEX(Sheet1!B$2:B$26,SMALL(IF(Sheet1!B$2:B$26>=Sheet1!$J$1,IF(Sheet1!B$2:B$26<=Sheet1!$J$2,ROW(Sheet1!B$2:B$26)-ROW(Sheet1!$B$2)+1)),ROWS(Sheet2!$A$15:A16))),"")}
A17	{=IFERROR(INDEX(Sheet1!B$2:B$26,SMALL(IF(Sheet1!B$2:B$26>=Sheet1!$J$1,IF(Sheet1!B$2:B$26<=Sheet1!$J$2,ROW(Sheet1!B$2:B$26)-ROW(Sheet1!$B$2)+1)),ROWS(Sheet2!$A$15:A17))),"")}
A18	{=IFERROR(INDEX(Sheet1!B$2:B$26,SMALL(IF(Sheet1!B$2:B$26>=Sheet1!$J$1,IF(Sheet1!B$2:B$26<=Sheet1!$J$2,ROW(Sheet1!B$2:B$26)-ROW(Sheet1!$B$2)+1)),ROWS(Sheet2!$A$15:A18))),"")}
A19	{=IFERROR(INDEX(Sheet1!B$2:B$26,SMALL(IF(Sheet1!B$2:B$26>=Sheet1!$J$1,IF(Sheet1!B$2:B$26<=Sheet1!$J$2,ROW(Sheet1!B$2:B$26)-ROW(Sheet1!$B$2)+1)),ROWS(Sheet2!$A$15:A19))),"")}
A20	{=IFERROR(INDEX(Sheet1!B$2:B$26,SMALL(IF(Sheet1!B$2:B$26>=Sheet1!$J$1,IF(Sheet1!B$2:B$26<=Sheet1!$J$2,ROW(Sheet1!B$2:B$26)-ROW(Sheet1!$B$2)+1)),ROWS(Sheet2!$A$15:A20))),"")}
A21	{=IFERROR(INDEX(Sheet1!B$2:B$26,SMALL(IF(Sheet1!B$2:B$26>=Sheet1!$J$1,IF(Sheet1!B$2:B$26<=Sheet1!$J$2,ROW(Sheet1!B$2:B$26)-ROW(Sheet1!$B$2)+1)),ROWS(Sheet2!$A$15:A21))),"")}
A22	{=IFERROR(INDEX(Sheet1!B$2:B$26,SMALL(IF(Sheet1!B$2:B$26>=Sheet1!$J$1,IF(Sheet1!B$2:B$26<=Sheet1!$J$2,ROW(Sheet1!B$2:B$26)-ROW(Sheet1!$B$2)+1)),ROWS(Sheet2!$A$15:A22))),"")}
A23	{=IFERROR(INDEX(Sheet1!B$2:B$26,SMALL(IF(Sheet1!B$2:B$26>=Sheet1!$J$1,IF(Sheet1!B$2:B$26<=Sheet1!$J$2,ROW(Sheet1!B$2:B$26)-ROW(Sheet1!$B$2)+1)),ROWS(Sheet2!$A$15:A23))),"")}
A24	{=IFERROR(INDEX(Sheet1!B$2:B$26,SMALL(IF(Sheet1!B$2:B$26>=Sheet1!$J$1,IF(Sheet1!B$2:B$26<=Sheet1!$J$2,ROW(Sheet1!B$2:B$26)-ROW(Sheet1!$B$2)+1)),ROWS(Sheet2!$A$15:A24))),"")}
B15	{=IFERROR(INDEX(Sheet1!C$2:C$26,SMALL(IF(Sheet1!B$2:B$26>=Sheet1!$J$1,IF(Sheet1!B$2:B$26<=Sheet1!$J$2,ROW(Sheet1!B$2:B$26)-ROW(Sheet1!$B$2)+1)),ROWS(Sheet2!$A$15:A15))),"")}
B16	{=IFERROR(INDEX(Sheet1!C$2:C$26,SMALL(IF(Sheet1!B$2:B$26>=Sheet1!$J$1,IF(Sheet1!B$2:B$26<=Sheet1!$J$2,ROW(Sheet1!B$2:B$26)-ROW(Sheet1!$B$2)+1)),ROWS(Sheet2!$A$15:A16))),"")}
B17	{=IFERROR(INDEX(Sheet1!C$2:C$26,SMALL(IF(Sheet1!B$2:B$26>=Sheet1!$J$1,IF(Sheet1!B$2:B$26<=Sheet1!$J$2,ROW(Sheet1!B$2:B$26)-ROW(Sheet1!$B$2)+1)),ROWS(Sheet2!$A$15:A17))),"")}
B18	{=IFERROR(INDEX(Sheet1!C$2:C$26,SMALL(IF(Sheet1!B$2:B$26>=Sheet1!$J$1,IF(Sheet1!B$2:B$26<=Sheet1!$J$2,ROW(Sheet1!B$2:B$26)-ROW(Sheet1!$B$2)+1)),ROWS(Sheet2!$A$15:A18))),"")}
B19	{=IFERROR(INDEX(Sheet1!C$2:C$26,SMALL(IF(Sheet1!B$2:B$26>=Sheet1!$J$1,IF(Sheet1!B$2:B$26<=Sheet1!$J$2,ROW(Sheet1!B$2:B$26)-ROW(Sheet1!$B$2)+1)),ROWS(Sheet2!$A$15:A19))),"")}
B20	{=IFERROR(INDEX(Sheet1!C$2:C$26,SMALL(IF(Sheet1!B$2:B$26>=Sheet1!$J$1,IF(Sheet1!B$2:B$26<=Sheet1!$J$2,ROW(Sheet1!B$2:B$26)-ROW(Sheet1!$B$2)+1)),ROWS(Sheet2!$A$15:A20))),"")}
B21	{=IFERROR(INDEX(Sheet1!C$2:C$26,SMALL(IF(Sheet1!B$2:B$26>=Sheet1!$J$1,IF(Sheet1!B$2:B$26<=Sheet1!$J$2,ROW(Sheet1!B$2:B$26)-ROW(Sheet1!$B$2)+1)),ROWS(Sheet2!$A$15:A21))),"")}
B22	{=IFERROR(INDEX(Sheet1!C$2:C$26,SMALL(IF(Sheet1!B$2:B$26>=Sheet1!$J$1,IF(Sheet1!B$2:B$26<=Sheet1!$J$2,ROW(Sheet1!B$2:B$26)-ROW(Sheet1!$B$2)+1)),ROWS(Sheet2!$A$15:A22))),"")}
B23	{=IFERROR(INDEX(Sheet1!C$2:C$26,SMALL(IF(Sheet1!B$2:B$26>=Sheet1!$J$1,IF(Sheet1!B$2:B$26<=Sheet1!$J$2,ROW(Sheet1!B$2:B$26)-ROW(Sheet1!$B$2)+1)),ROWS(Sheet2!$A$15:A23))),"")}
B24	{=IFERROR(INDEX(Sheet1!C$2:C$26,SMALL(IF(Sheet1!B$2:B$26>=Sheet1!$J$1,IF(Sheet1!B$2:B$26<=Sheet1!$J$2,ROW(Sheet1!B$2:B$26)-ROW(Sheet1!$B$2)+1)),ROWS(Sheet2!$A$15:A24))),"")}
C15	{=IFERROR(INDEX(Sheet1!E$2:E$26,SMALL(IF(Sheet1!B$2:B$26>=Sheet1!$J$1,IF(Sheet1!B$2:B$26<=Sheet1!$J$2,ROW(Sheet1!B$2:B$26)-ROW(Sheet1!$B$2)+1)),ROWS(Sheet2!$A$15:A15))),"")}
C16	{=IFERROR(INDEX(Sheet1!E$2:E$26,SMALL(IF(Sheet1!B$2:B$26>=Sheet1!$J$1,IF(Sheet1!B$2:B$26<=Sheet1!$J$2,ROW(Sheet1!B$2:B$26)-ROW(Sheet1!$B$2)+1)),ROWS(Sheet2!$A$15:A16))),"")}
C17	{=IFERROR(INDEX(Sheet1!E$2:E$26,SMALL(IF(Sheet1!B$2:B$26>=Sheet1!$J$1,IF(Sheet1!B$2:B$26<=Sheet1!$J$2,ROW(Sheet1!B$2:B$26)-ROW(Sheet1!$B$2)+1)),ROWS(Sheet2!$A$15:A17))),"")}
C18	{=IFERROR(INDEX(Sheet1!E$2:E$26,SMALL(IF(Sheet1!B$2:B$26>=Sheet1!$J$1,IF(Sheet1!B$2:B$26<=Sheet1!$J$2,ROW(Sheet1!B$2:B$26)-ROW(Sheet1!$B$2)+1)),ROWS(Sheet2!$A$15:A18))),"")}
C19	{=IFERROR(INDEX(Sheet1!E$2:E$26,SMALL(IF(Sheet1!B$2:B$26>=Sheet1!$J$1,IF(Sheet1!B$2:B$26<=Sheet1!$J$2,ROW(Sheet1!B$2:B$26)-ROW(Sheet1!$B$2)+1)),ROWS(Sheet2!$A$15:A19))),"")}
C20	{=IFERROR(INDEX(Sheet1!E$2:E$26,SMALL(IF(Sheet1!B$2:B$26>=Sheet1!$J$1,IF(Sheet1!B$2:B$26<=Sheet1!$J$2,ROW(Sheet1!B$2:B$26)-ROW(Sheet1!$B$2)+1)),ROWS(Sheet2!$A$15:A20))),"")}
C21	{=IFERROR(INDEX(Sheet1!E$2:E$26,SMALL(IF(Sheet1!B$2:B$26>=Sheet1!$J$1,IF(Sheet1!B$2:B$26<=Sheet1!$J$2,ROW(Sheet1!B$2:B$26)-ROW(Sheet1!$B$2)+1)),ROWS(Sheet2!$A$15:A21))),"")}
C22	{=IFERROR(INDEX(Sheet1!E$2:E$26,SMALL(IF(Sheet1!B$2:B$26>=Sheet1!$J$1,IF(Sheet1!B$2:B$26<=Sheet1!$J$2,ROW(Sheet1!B$2:B$26)-ROW(Sheet1!$B$2)+1)),ROWS(Sheet2!$A$15:A22))),"")}
C23	{=IFERROR(INDEX(Sheet1!E$2:E$26,SMALL(IF(Sheet1!B$2:B$26>=Sheet1!$J$1,IF(Sheet1!B$2:B$26<=Sheet1!$J$2,ROW(Sheet1!B$2:B$26)-ROW(Sheet1!$B$2)+1)),ROWS(Sheet2!$A$15:A23))),"")}
C24	{=IFERROR(INDEX(Sheet1!E$2:E$26,SMALL(IF(Sheet1!B$2:B$26>=Sheet1!$J$1,IF(Sheet1!B$2:B$26<=Sheet1!$J$2,ROW(Sheet1!B$2:B$26)-ROW(Sheet1!$B$2)+1)),ROWS(Sheet2!$A$15:A24))),"")}
Press CTRL+SHIFT+ENTER to enter array formulas.