Forum Discussion
bdgardner
Oct 31, 2022Copper Contributor
IF AND Formula Help
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 ...
HansVogelaar
Oct 31, 2022MVP
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.