Nested If logic is not working

[Closed]
Report
Posts
1
Registration date
Sunday December 15, 2013
Status
Member
Last seen
December 15, 2013
-
Please tell me what's wrong in below formula:
=IF((AND((HLOOKUP(A1,$A$1:$F$2,2,0)="Yes"),(HLOOKUP(G1,G1:L2,2,0)="Green"))),"Compliant",IF((AND(AND((HLOOKUP(A1,$A$1:$F$2,2,0)="Yes"),(HLOOKUP(G1,G1:L2,2,0)="Orange"))),(NOT(ISBLANK(N2)))),"Compliant",IF((AND(AND((HLOOKUP(A1,$A$1:$F$2,2,0)="Yes"),(HLOOKUP(G1,G1:L2,2,0)="RED"))),(NOT(ISBLANK(N2)))),"Compliant",IF((AND(AND((HLOOKUP(A1,$A$1:$F$2,2,0)="Yes"),(HLOOKUP(G1,G1:L2,2,0)="Yellow"))),(NOT(ISBLANK(N2)))),"Compliant",IF((AND(AND((HLOOKUP(A1,$A$1:$F$2,2,0)="Yes"),(HLOOKUP(G1,G1:L2,2,0)="NA"))),(NOT(ISBLANK(N2)))),"Compliant",IF((AND(AND((HLOOKUP(A1,$A$1:$F$2,2,0)="Yes"),(HLOOKUP(G1,G1:L2,2,0)="NULL"))),(NOT(ISBLANK(N2)))),"Compliant","Non Compliant"))))

Quick Help is appreciated much.