COUNTIF modification to look take into consideration a second criteria

[RodneyC]

Shout out to Joe4 who helped me get this far.

I'm using this formula to produce a result of either Y or N based on the value in InclusionList!$A$2:$A$32

=IF(COUNTIF(InclusionList!$A$2:$A$32,B4)>0,"Y","N")

In reality, I have values in $A$2:$A$1000 but am only looking at $A$2:$A$32 because those have a specific date associated with them that is in column B on the InclusionList tab. For example, lets say that date in B2:B32 is 9/8/2022. B33:B65 may have 9/11/2022 and so on until we reach the end of the measured period of time. I need to modify the formula above so that it looks in cell D2 and only produces a Y if the conditions in the original formula are met AND InclusionList!$B:$1000 equals the value in D2.

Thanks on advance

 

[SanjayGMusafir]

Try this -

=IF(COUNTIFS(InclusionList!$A$2:$A$1000,B4,InclusionList!$B:$1000,$D$2)>0,"Y","N")

 

[RodneyC]

Try this -

=IF(COUNTIFS(InclusionList!$A$2:$A$1000,B4,InclusionList!$B:$1000,$D$2)>0,"Y","N")

Excel said there was a typo and changed the formula to this: =IF(COUNTIFS(InclusionList!$A$2:$A$1000,B4,InclusionList!$B$1000,$D$2)>0,"Y","N") which produces a #VALUE result

 

[SanjayGMusafir]

Excel said there was a typo and changed the formula to this: =IF(COUNTIFS(InclusionList!$A$2:$A$1000,B4,InclusionList!$B$1000,$D$2)>0,"Y","N") which produces a #VALUE result

There is an error in the formula I gave and system corrected.

Try this and update -

=IF(COUNTIFS(InclusionList!$A$2:$A$1000,B4,InclusionList!$B$2:$B$1000,$D$2)>0,"Y","N")

Also, note that I have populated formula assuming the date to look up is in cell D2 thus making cell D2 absolute reference.

 

[RodneyC]

There is an error in the formula I gave and system corrected.

Try this and update -

=IF(COUNTIFS(InclusionList!$A$2:$A$1000,B4,InclusionList!$B$2:$B$1000,$D$2)>0,"Y","N")

Also, note that I have populated formula assuming the date to look up is in cell D2 thus making cell D2 absolute reference.

That worked, thank you. and yes, $D$2 is a constant

 

[SanjayGMusafir]

Glad to help you