Return "Yes" or "No" if row contain multiple criteria matching from different arrays

[catiexcel]

In this table, column G-M, I need to return "Yes" using three criteria: Team, Event, and Error. It is looking for whether each criteria match in three other arrays. Is this possible?

This is the Issue Logs tab

This is the Admin tab where two of the arrays are that the Events and Errors should match to.

 

[ExceLoki]

i think this is what you're looking for. check it out and let me know.
Issues Log

Return Yes or No if row contain multiple criteria matching from different arrays.xlsx
	A	B	C	D	E	F	G	H	I	J	K	L	M	N
1	Team	Task No	Event	Error Type	Score	Notes (manual)	Master Home	Back Up Home	OTB Home	Master Away	Back Up Away	OTB Away	Hot Events	Locations
2	SYD		Flop	Player ID			Yes	Yes
3	PEN		Metres Set	Player ID								Yes
4	PEN		Player Onside	Coordinates
5	PEN		Marker	Coordinates
6	SYD		Support Run	Player ID					Yes
7	SYD		Charge Down	Player ID					Yes
8	PEN		20m Dropout	Player ID							Yes		Yes
9	SYD		Point Scoring	Coordinates									Yes	Yes
10	SYD		Carrying and Breaking	Coordinates
11	SYD		Conversion	Player ID				Yes
12	PEN		Captains Challenge	Player ID									Yes
13	PEN		Field Goal - 2 Point	Coordinates									Yes	Yes
14	PEN		Shot Clock	Coordinates									Yes	Yes
15	PEN		Referee	Coordinates									Yes	Yes
16	SYD		Stoppages	Coordinates
17	SYD		Error	Coordinates
18	SYD		Ball Runs	Coordinates
19	PEN		Play The Ball	Coordinates
20	SYD		Tackles	Coordinates
21	PEN		Tackles	Coordinates
Issues Log

Cell Formulas
Range	Formula
G2:L21	G2	=IFERROR(IF(AND($A2=VLOOKUP(TEXTAFTER(G$1," ",LEN(G$1)-LEN(SUBSTITUTE(G$1," ",""))),$P$2:$Q$3,2,FALSE),MATCH($C2,FILTER(Admin!$A$2:$E$37,TEXTBEFORE(G$1," ",LEN(G$1)-LEN(SUBSTITUTE(G$1," ","")))=Admin!$A$1:$E$1,""),0)>0,MATCH($D2,FILTER(Admin!$G$1:$K$9,TEXTBEFORE(G$1," ",LEN(G$1)-LEN(SUBSTITUTE(G$1," ","")))=Admin!$G$1:$K$1,""),0)>0),"Yes",""),"")
M2:N21	M2	=IFERROR(IF(AND(MATCH($C2,FILTER(Admin!$A$2:$E$37,M$1=Admin!$A$1:$E$1,""),0)>0,MATCH($D2,FILTER(Admin!$G$1:$K$9,M$1=Admin!$G$1:$K$1,""),0)>0),"Yes",""),"")

-----------------------
Admin

Return Yes or No if row contain multiple criteria matching from different arrays.xlsx
	A	B	C	D	E	F	G	H	I	J	K
1	Master	Back Up	OTB	Hot Events	Locations		Master	Back Up	OTB	Hot Events	Locations
2	Flop	Flop	Decoy	Kick Off	Kick Off		Missing	Missing	Missing	Missing	Coordinates
3	Stoppages	Stoppages	End Of Kick	Half Break	Half Break		Wrongly Given	Wrongly Given	Wrongly Given	Wrongly Given
4	Error	Error	Metres Set	Try Scoring	Try Scoring		Player ID	Player ID	Player ID	Player ID
5	Ball Runs	Ball Runs	Player Onside	Try Assist	Try Assist			Detail 2	Detail 2	Detail 2
6	Play The Ball	Play The Ball	Marker	Kick Awarded	Kick Awarded			Detail 3	Detail 3	Detail 3
7	Kicking	Kicking	Support Run	Try Involvement	Try Involvement			Detail 4	Detail 4	Detail 4
8	Offload	Offload	Charge Down	Line Break	Line Break			Detail 5	Detail 5	Detail 5
9	Pass	Pass	Defender out of play - At Ruck	Line Break Assist	Line Break Assist			Timestamp	Timestamp	Coordinates
10	Receipt	Receipt	Dummy Pass	Line Break Involvement	Line Break Involvement
11	Secondary Contact	Secondary Contact	Injury	On Report	On Report
12	Start Set	Start Set	Injury Result	Tap Kick	Tap Kick
13	Set Complete	Set Complete	Kick Defused	Penalty Kick	Penalty Kick
14	Tackles	Tackles	Kick Pressure	20m Restart	20m Restart
15	Repeat Set	Repeat Set	Kick Shepherd	20m Dropout	20m Dropout
16	Break Cause	Break Cause	Kick Shielf	Point Scoring	Point Scoring
17	Try Cause	Try Cause	Player Offside	Penalty Goal	Penalty Goal
18	Tackle Complete	Tackle Complete		Line Dropout	Line Dropout
19		20m Restart		EOP	EOP
20		20m Dropout		Sin Bin	Sin Bin
21		Point Scoring		Substitution In	Substitution In
22		Carrying and Breaking		Substitution Out	Substitution Out
23		Conversion		Sent Off	Sent Off
24		Kick Chase		Captains Challenge	Captains Challenge
25		Kick Off		Ruck Infringement	Ruck Infringement
26		Line Dropout		Scrum	Scrum
27		Penalty		Half Break	Half Break
28		Penalty Goal		Field Goal	Field Goal
29		Penalty Kick		Field Goal - 2 Point	Field Goal - 2 Point
30		Ruck Infringement		Reason for Review	Reason for Review
31		Scrum		Shot Clock	Shot Clock
32		Sent Off		Cautioned	Cautioned
33		Sin Bin		Penalty	Penalty
34		Tap Kick		Kick Chase	Kick Chase
35		Video		Referee	Referee
36		Substitution In			Decoy
37		Substitution Out			End of Kick
Admin

 

[catiexcel]

@ExceLoki That is incredible, that's exactly what I needed!! Thank you so much, works perfectly.

 

[ExceLoki]

happy to help