Forum Discussion
Solved
Lookup another row with multiple criteria
Okay, so I've hit a wall. I'm hoping some excel wizard out there can help me. I am trying to search an entire excel document for any row that matches all 4 criteria, and display True or False in ...
In D2:
=IF(A2="medical",COUNTIFS($A$2:$A$100000,"therapy",$B$2:$B$100000,B2,$C$2:$C$100000,C2,$D$2:$D$100000,"Yes")>0,"N/A")
Fill down.
In D2:
=IF(A2="medical",COUNTIFS($A$2:$A$100000,"therapy",$B$2:$B$100000,B2,$C$2:$C$100000,C2,$D$2:$D$100000,"Yes")>0,"N/A")
Fill down.
That's a simple fix. Thanks so much!