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.
I have used COUNTIFS to determine whether the record you require is present or not
= IF([@VisitType]="medical",
COUNTIFS(
[PatientNum], [@PatientNum],
[VisitDate], [@VisitDate],
[VisitType],"therapy",
[VisitComplete],"yes"),
"" )The data is entered as an Excel Table and I also used number formatting to convert the {1,0} to "Yes"/"No".
- Thanks Peter, that's the solution that Hans gave me above. That's definitely simpler than what I was trying to do. Thanks for the alternative script
