Problem with expression

[Lucinda_Mason]

I can’t get the last part of this expression to work. It does not pull all the data it should.

AND(
[SCOPE_NO]=3,[START_DATE]<=Today(),[END_DATE]>=Today()+7,

OR(
AND(LOOKUP(USEREMAIL(), Users, USER_EMAIL,FAMILY_GROUP)=“GEO”,
LOOKUP(USEREMAIL(), Users, USER_EMAIL, GEO_NO)=[GEO_NO]),

   AND([PI_NO]>4, LOOKUP(USEREMAIL(), Users, USER_EMAIL, FAMILY_GROUP)="JFP"),

   AND([PI_NO]=4, 
         OR(LOOKUP(USEREMAIL(), Users, USER_EMAIL, GEO_NO)=[GEO_NO],
                LOOKUP(USEREMAIL(), Users, USER_EMAIL, FAMILY_GROUP)="JFP")

)))

---

AND([PI_NO]=4,
OR(LOOKUP(USEREMAIL(), Users, USER_EMAIL, GEO_NO)=[GEO_NO],
LOOKUP(USEREMAIL(), Users, USER_EMAIL, FAMILY_GROUP)=“JFP”)

Does not pull the data from the “LOOKUP(USEREMAIL(), Users, USER_EMAIL, GEO_NO)=[GEO_NO]” part.

In this case, where PI_NO=4 I want it to pull all the records with GEO_NO corresponding to the USERs.GEO_NO and all the records where the USERs.FAMILY_GROUP=JFP

What am I missing? Thanks.