No, the first few are NA, the rest are compliant. There is a random
assortment. Thanks for trying.

"Glenn" wrote:

PAL wrote:
I have a multi column (10), multi row(1000s) table. I am trying the
following formula, with if two conditions are true.

=IF(AND(Raw!$D$2:$D$2368=F2,Raw!$R$2:$R$2368""), "Compliant",
"Non-Compliant").

It doesn't seem to work. Ideas.

Thanks.


Is this what you are looking for?


=IF(INDEX(Raw!$R$2:$R$2368,MATCH(F2,Raw!$D$2:$D$23 68,0))"",
"Compliant","Non-Compliant")
.