Conditional Index Match array

  • I have this array formula: {=IFERROR(INDEX(Table!$C$2:$C$1000,MATCH(1,(Data!CT45=Table!$B$2:$B$1000)*(Data!CN45=Table!$A$2:$A$1000),0)),0)} but I only want to proceed with it IF (Data!CX43="False") otherwise return "0"

    How do I incorporate the two formula? The array part has thrown me.

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!