Automatic daily checklist for the document received

Hi I have a problem. I'm receiving a lot of documents.

I received 1 document for each brand but it has 2 or more location (sheet 1).
I want to monitor if i received all the documents by automatic checklist.

I'm entering the brand, location and date.
I want that when I enter the date it will show in the next sheet that the document is arrived like check sign or any thing that means received.

I attached the document for your reference.

Please help me on this work related needs.

Thank you very much.

Hi I try in E4 but its not working. It shows a square sign. Maybe please can you attached the file that i can download with. Thanks

Attached file has Ford's formula.

Yes its working but when I'm verifying the accuracy. I found out that;
1. E Pro The Mall document I still did not received but its already a check sign is coming.
2. I copied the formula from March 1 to 5 that is E4 to 17 and I4 to 17. The march 4 is already have check sign where in I did not yet received the document.

Try

=IF(ISNUMBER(MATCH($B4&DATEVALUE(E$3&$E$2),INDEX('Sheet 1'!$B$7:$B$1000&'Sheet 1'!$D$7:$D$1000,0),0)),"X","")

as it appears to be based on BRAND not LOCATION

Oh sorry. I want it based also with brand.

It will be based on Brand, Location and date.

I’m receiving daily sales document of the brand each day but I has 2 or more locations (malls).
I want to monitor if I received the brand sales documents per location and date.

Thank you very much.

This works great.

Can i request that Sheet 1 and checklist will be on different workbook.

The original file works like this. I just put it in the same work book here in my request.

Thanks