Exel Filter formula with multiple criterias

[esmarques]

Hello,
I am trying to add some filters that are not returning what I would like. If someone could help ? Only looking for the formulas on IP Progress Tracker Tab columns A, D and G.
In "Data" tab, data on colums L and M are related to each other, column M is a type related to column L, same as for columns O and P

At the moment I believe the filters I entered are only looking the matches on columns L and M but not O and P.

For example on Ip Progress Tracker tab, Cell A4, the result for that filter at the moment should be Stone Carves and Drumming
Filter on D4 should return Knights and Bloco
Filter on G4 - Dovestone Meeting
...
A20 - none
D20 - none
G20 - Dance

Any help welcome

thank you

"Data" Tab:

Book1
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U
1	Reference	Date [Happening]	Arrangement Reference	Description	Sales Manager	Customer	Local Authority	Activity Outcome (NPO)	Activity Outcome Notes	Sub-Activity Outcome (NPO)	Sub-Activity Outcome Notes	IP Tracker (NPO) 1	Type 1	IP Tracker Notes 1	IP Tracker (NPO) 2	Type 2	IP Tracker Notes 2	Number of participants	Final Numbers	Number of people involved	Final number?
2	3827	4/1/24	KNI001	Knights				Act.6 - high quality arts venue				Environmental Responsibility	Skills development							0	checked
3	354	4/1/24	25	Dovestones Meeting											Environmental Responsibility	People and representation
4	2131	4/2/24	166	Bloco				Act.2 - Artist Dev	wqerqwerqer	Act.1 - Young Artist Dev		Ambition and Quality	People and representation		Environmental Responsibility	Skills development		0	unchecked
5	2132	4/2/24	166	Bloco				Act.2 - Artist Dev	21231231231	Act.2 - Artist Dev		Ambition and Quality	People and representation	22233	Environmental Responsibility	Skills development	FRRF	0	unchecked
6	2538	4/2/24	166	Stone Carvers				Act.2 - Artist Dev	prprprpr	Act.2 - Artist Dev		Environmental Responsibility						0	unchecked
7	3827	4/1/24	KNI001	Knights				Act.6 - The Vale as a high quality arts venue												0	checked
8	2538	4/2/24	166	Dance				Act.2 - Artist Dev	prprprpr	Act.2 - Artist Dev						People and representation		0	unchecked
9	2538	4/2/24	166	Drumming				Act.2 - Artist Dev	prprprpr	Act.2 - Artist Dev					Environmental Responsibility			0	unchecked
10
11
Data

"IP Progress tracker":

Book1
	A	B	C	D	E	F	G	H	I
1	ENVIRONMENTAL RESPONSIBILITY
2	NO TYPE			SKILLS DEVELOPMENT			PEOPLE AND REPRESENTATION
3	Activity	No of Activities	Notes	Activity	No of Activities	Notes	Activity	No of Activities	Notes
4	Stone Carvers	1		Knights	0	none	None	0	none
5		0			0			0
6
7
8
9	AMBITION AND QUALITY
10	NO TYPE			SKILLS DEVELOPMENT			PEOPLE AND REPRESENTATION
11	Activity	No of Activities	Notes	Activity	No of Activities	Notes	Activity	No of Activities	Notes
12	none	0		None	0	none	Bloco	0	none
13		0			0			0
14
15
16
17	NO TRACKER
18	NO TYPE			SKILLS DEVELOPMENT			PEOPLE AND REPRESENTATION
19	Activity	No of Activities	Notes	Activity	No of Activities	Notes	Activity	No of Activities	Notes
20	Dance	1		None	0	none	None	0	none
21		0			0			0
22
23
IP Progress Tracker

Cell Formulas
Range	Formula
A4,A12	A4	=UNIQUE(LET(f,FILTER(Data!$D$2:$Q$1000,(Data!$D$2:$D$1000<>"")*(Data!$L$2:$L$1000=A1)),d,INDEX(f,,1),FILTER(d,ISNA(XMATCH(d,SORT(UNIQUE(FILTER(d,(INDEX(f,,10)<>"")+(INDEX(f,,13)<>"")))),,2)),"none")))
B20:B21,B12:B13,B4:B5	B4	=COUNTIF(Data!D:D,A4)
C4:C5	C4	=TEXTJOIN(", ",,UNIQUE(FILTER(CHOOSECOLS(Data!$N:$Q,1,4),Data!$D:$D=A4,"none")))
D4,G4,D12,G12	D4	=IFERROR(UNIQUE(FILTER(Data!$D:$D,(Data!$L:$L=$A1)*(Data!$M:$M=D2))),"None")
H20:H21,E20:E21,H12:H13,E12:E13,E4:E5,H4:H5	E4	=COUNTIF('[Outcome_KPI_ analysis.xlsx]Data'!$D:$D,D4)
I20:I21,F20:F21,I12:I13,F12:F13,F4:F5,I4:I5	F4	=TEXTJOIN(", ",,UNIQUE(FILTER(CHOOSECOLS('[Outcome_KPI_ analysis.xlsx]Data'!$N:$Q,1,4),'[Outcome_KPI_ analysis.xlsx]Data'!$D:$D=D4,"none")))
C20:C21,C12:C13	C12	=TEXTJOIN(", ",,UNIQUE(FILTER(CHOOSECOLS('[Outcome_KPI_ analysis.xlsx]Data'!$I:$K,1,3),'[Outcome_KPI_ analysis.xlsx]Data'!$D:$D='[Outcome_KPI_ analysis.xlsx]Activity Outcomes'!A78,"none")))
A20	A20	=UNIQUE(LET(f,FILTER(Data!$D$2:$Q$1000,Data!$D$2:$D$1000<>""),d,INDEX(f,,1),FILTER(d,ISNA(XMATCH(d,SORT(UNIQUE(FILTER(d,(INDEX(f,,9)<>"")+(INDEX(f,,12)<>"")))),,2)),"none")))
D20,G20	D20	=IFERROR(UNIQUE(FILTER(Data!$D:$D,(Data!$L:$L=$A17)*(Data!$M:$M=D18)+(Data!$O:$O=$A17)*(Data!$M:$M=D18))),"None")

 

[esmarques]

Hello, I may have found a way round using VSTACK... thank you all anyway.

 

[Fluff]

Good to hear you got the solution.
If you would like to post the solution then it is perfectly fine to mark your post as the solution to help future readers. Otherwise, please do not mark a post that doesn't contain a solution.