filter 2 columns and put in a single column

[ExcelNewbie2020]

I have these 2 tables sheet 1(incoming and outgoing). If I input the date in K2 (sheet 2), it will filter the number from both tables that match the dates. I want the filtered number from both tables to place in a single column. thank you so much

Please note that the data from sheet 1 (incoming and outgoing) is dynamic.

Book2
	A	B	C	D	E	F	G	H	I	J	K
1	SHEET 1							SHEET 2
2	INCOMING			OUTGOING				EXPECTED RESULT		DATE:	29-03-23
3	DATE	NUMBER		DATE	NUMBER			NUMBER
4	29-03-23	1001		29-03-23	2001			1001
5	29-03-23	1002		29-03-23	2002			1002
6	29-03-23	1003		29-03-23	2003			1003
7	29-03-23	1004		29-03-23	2004			1004
8	29-03-23	1005		29-03-23	2005			1005
9	29-03-23	1006		29-03-23	2006			1006
10	29-03-23	1007						1007
11	29-03-23	1008						1008
12	29-03-23	1009						1009
13	29-03-23	1010						1010
14	29-03-23	1011						1011
15	29-03-23	1012						1012
16	29-03-23	1013						1013
17								2001
18								2002
19								2003
20								2004
21								2005
22								2006
23
24
Sheet1

 

[etaf]

as you have version 365
how about
=VSTACK(FILTER(B4:B100,A4:A100=K2),FILTER(E4:E100,D4:D100=K2))
need just to change the range to match sheet names

Book1
	A	B	C	D	E	F	G	H	I	J	K	L	M
1	SHEET 1							SHEET 2
2	INCOMING			OUTGOING				EXPECTED RESULT		DATE:	45014		Vstack & Filter
3	DATE	NUMBER		DATE	NUMBER			NUMBER
4	45014	1001		45014	2001			1001					1001
5	45014	1002		45014	2002			1002					1002
6	45014	1003		45014	2003			1003					1003
7	45014	1004		45014	2004			1004					1004
8	45014	1005		45014	2005			1005					1005
9	45014	1006		45014	2006			1006					1006
10	45014	1007						1007					1007
11	45014	1008						1008					1008
12	45014	1009						1009					1009
13	45014	1010						1010					1010
14	45014	1011						1011					1011
15	45014	1012						1012					1012
16	45014	1013						1013					1013
17								2001					2001
18								2002					2002
19								2003					2003
20								2004					2004
21								2005					2005
22								2006					2006
23
Sheet1

Cell Formulas
Range	Formula
M4:M22	M4	=VSTACK(FILTER(B4:B100,A4:A100=K2),FILTER(E4:E100,D4:D100=K2))
Dynamic array formulas.

 

[ExcelNewbie2020]

as you have version 365
how about
=VSTACK(FILTER(B4:B100,A4:A100=K2),FILTER(E4:E100,D4:D100=K2))
need just to change the range to match sheet names

Book1
	A	B	C	D	E	F	G	H	I	J	K	L	M
1	SHEET 1							SHEET 2
2	INCOMING			OUTGOING				EXPECTED RESULT		DATE:	45014		Vstack & Filter
3	DATE	NUMBER		DATE	NUMBER			NUMBER
4	45014	1001		45014	2001			1001					1001
5	45014	1002		45014	2002			1002					1002
6	45014	1003		45014	2003			1003					1003
7	45014	1004		45014	2004			1004					1004
8	45014	1005		45014	2005			1005					1005
9	45014	1006		45014	2006			1006					1006
10	45014	1007						1007					1007
11	45014	1008						1008					1008
12	45014	1009						1009					1009
13	45014	1010						1010					1010
14	45014	1011						1011					1011
15	45014	1012						1012					1012
16	45014	1013						1013					1013
17								2001					2001
18								2002					2002
19								2003					2003
20								2004					2004
21								2005					2005
22								2006					2006
23
Sheet1

Cell Formulas
Range	Formula
M4:M22	M4	=VSTACK(FILTER(B4:B100,A4:A100=K2),FILTER(E4:E100,D4:D100=K2))
Dynamic array formulas.

thanks man..it worx.. really appreciated

 

[etaf]

You are welcome