IF AND Formula Help

Occasional Visitor

I have a spreadsheet that contains multiple columns of text data. I am trying to write an IF AND statement that looks for two conditions (from two columns of data) to be true and return the value of a third column into the cell. When I write the function using the fx feature, the value I expect shows as the true condition but the result returns FALSE.

 

Formula

IF(AND('Template 2.0'!B:B='RCM Heat Map'!A3,'Template 2.0'!A:A='RCM Heat Map'!B2),'Template 2.0'!Q3)

 

 

1 Reply

@bdgardner 

Perhaps

 

=INDEX('Template 2.0'!$Q$1:$Q$1000, MATCH(1, ('Template 2.0!$B$1:$B$1000='RCM Heat Map'!A3)*('Template 2.0'!$A$1:$A$1000='RCM Heat Map'!B2), 0))

 

If you don't have Microsoft 365 or Office 2021, confirm the formula by pressing Ctrl+Shift+Enter.