index match

[coda1395]

I have an issue that I think can be solved using Index/Match but I'm honestly not quite sure how to best structure my data. Here's what i'm trying to solve for and attached a sample. Tab #1 (Items) list the purchaser in column A and priority in column D. I'm trying to match that against the store tab.

For example, Store 1002 and Jodi = B. On the items tab, where Jodi and B match, I would like a Yes or 1 in that corresponding cell. I'm not sure if I'm explaining this correctly but hopefully the attachment helps. Thanks in advance
Attached Files Attached Files