IF condition FALSE then INDEX MATCH Array

[rinconpaul]

I want to combine two formulas in an IF statement? I have this formula: IF (Data!CX43="False"), then proceed with 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)} otherwise return "0".

I've googled the "google' out of this query, to no avail. Seems like it can't be done?

 

[Aladin Akyurek]

Assuming that we have here the logical FALSE, not just text... Control+shift+enter:

=IF(Data!CX43=FALSE,

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)​

,0)

 

[rinconpaul]

Aladin, that works! I had the exact same formula as you in the many tries I had, but the secret was? I had FALSE as "FALSE". Those quotation marks were the culprits! Well done to you and thanks for taking the time to reply.

 

[Aladin Akyurek]

Aladin, that works! I had the exact same formula as you in the many tries I had, but the secret was? I had FALSE as "FALSE". Those quotation marks were the culprits! Well done to you and thanks for taking the time to reply.

You are welcome. Double quoting makes it text. Put otherwise, it loses its logical value identity.