List all matching values between two named ranges based on criteria

[mehidy1437]

Hi, I have got this here , now I need to get the list of matching value at cell J3 to downwards.
How should I alter this formula to get the matching values?
I'd be grateful if anyone could help with this?

Book1
	A	B	C	D	E	F	G	H	I	J
1	evaluated_name			executives	exit_date				NOT MATCH	MATCH
2
3	aa			aa	on duty				kk
4	bb			kk	on duty				gg
5	cc			cc	on duty				jj
6	dd			dd	on duty
7	ee			gg	on duty
8	ff			hh	out duty
9				jj	on duty
Sheet3

Cell Formulas
Range	Formula
I3:I9	I3	=IFERROR(INDEX(executives,MATCH(1,(COUNTIF($I$2:I2,executives)=0)*(exit_date="On Duty")*(ISERROR(MATCH(executives,evaluated_name,0))),0)),"")
Press CTRL+SHIFT+ENTER to enter array formulas.

Named Ranges
Name	Refers To	Cells
evaluated_name	=Sheet3!$A$3:$A$8	I3:I9
executives	=Sheet3!$D$3:$D$9	I3:I9
exit_date	=Sheet3!$E$3:$E$9	I3:I9

 

[Fluff]

Fraid I don't know how to do that.

 

[mehidy1437]

That's okay, thanks for your kind feedback.