Formula not working for match with criteria

[SuzyQPA2]

I am comparing two different worksheet columns and if SSN from worksheet AM-FID is not found on worksheet AM-IBX and the person is identified as "active assignment" in column I on worksheet AM-FID then...
I want to either highlight it (which i tried with conditional formatting and wouldn't work across worksheets) or have a column for True/False or have it bring that Row that doesn't have a SSN on both sheets and doesn't have active assignment to AM-differences worksheet

I got a matching formula working
=ISNA(MATCH(D3,'AM-IBX'!$C$2:$C$110,0))
it identified if the item wasn't on the other sheet with a true/false, but i couldn't add a condition that if column I = "active assignment" vs terminated then bring the data to a different worksheet from that row or, even identify it as true....

I tried this as well but it didn't work.
=INDEX('AM-IBX'!$C$2:$C$110,MATCH(D3,IF('AM-FID'!$I$3:$I$181="active assignment",TRUE),0))

 

[SuzyQPA2]

Excel Workbook
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T
2	Orig.Date Entered	Last Date Updated	SSN	Employee Name	Employee #	Assignment #	Prmary Assignment	Assignment Status	Payroll	Employment Category	Dept/Cost Center	Dept/Cost Center #	Work Location Description	Plan Type	Plan Code	Plan Name	Primary Carrier	Coverage Option Description	Coverage Type	Not on IBC
3	9/8/2010	9/8/2010	867532011	Doe, Jane	1	1	Y	Active Assignment	AM	Fulltime-Regular	5	5	NJ	Medical	*	Waived	*	*	*	FALSE
4	3/9/2011	3/31/2011	551551234	Mouse, Mickey	2	2	Y	Terminate Assignment	AM	Fulltime-Regular	8	8	NJ	Medical	HLFA	HMO LOW FT- AMERIHEALTH	AMERIHEALTH	HMO	SINGLE	TRUE
AM-FID