Help with Index and Checklists

[adflamm7]

I am familiar with vLookUP and I can't search multiple criteria when using vLookup. So I assume I need to use Index to achieve what I want. In the example attached, I would like sheet one to look through the submissions in sheet 2 and tell me if an opening Checklist, Closing Checklist, and Dough sheet has been submitted Today for each store. If so, "Yes", if not, "No". The submissions are due once a day, so I would like it to attached to today's day, if possible.

Thank you very much in advance. This forum has taught me so much about vlookup. Index is the next lesson.

https://drive.google.com/file/d/1VVSSQaiXpOHWAQgTS2QFrjt1bUPgV6XW/view?usp=sharing

 

[Ron Coderre]

Using your googledocs example....
This formula, copied across to the right and down, flags stores that submitted the referenced document on the referenced date:

E2: <bdo dir="ltr">=sumproduct(([COLOR=#f7981d]Sheet2!$B$2:$B$791[/COLOR]=[COLOR=#7e3794]$A2[/COLOR])
*([COLOR=#11a9cc]Sheet2!$A$2:$A$791[/COLOR]=[COLOR=#a61d4c]B$1[/COLOR])
*(--right([COLOR=#4285f4]Sheet2!$K$2:$K$791[/COLOR],12)=date(2018,6,30)))

</bdo>
Is that something you can work with?