Checking 2 values to update a cell

Hey guys, I'm making an excel calendar of sorts but am running into trouble when I want to mark a line item as 'Scheduled'. Now, it is only 'Scheduled' if the Item ID and Regional Name match from the calendar to the deals list. So, there are multiple Item IDs but in different regions meaning a simple countif wouldn't work.

Any help would be appreciated. A sample of the workbook has been attached.

Thanks and KCCO

=SUMPRODUCT((Calendar!$C$2:$C$16=B2)*(Calendar!$D$2:$CQ$16=A2))>0 ??

In D2 of 'Deals list'

=COUNTIF(INDEX(INDEX(Calendar!$D$2:$CQ$16,MATCH(B2,Calendar!$C$2:$C$16,0),0),0),A2)>0

TRUE indicates 'scheduled', FALSE indicates 'not scheduled'

Hi,

In D2:

=IF(SUMPRODUCT((Calendar!$D$2:$CQ$16=[@StorefrontItemID])*(Calendar!$C$2:$C$16=[@[Storefront Item Region]]))>0,"Yes","")

Regards

Great that's perfect. Thanks guys!