Avoid circular reference in lookup

Hello,
Thank you for looking at my post.

I send out a manifest of items to customers consisting the date sent and ID of the item. The customer sends a 'Received' file back and I do a lookup from my manifest to the Received file.
What I'm trying to achieve is for if any ID for a given date is on the Received file, then mark everything sent on that date as received. So far my attempts produce circular references so I was looking for a way to do this with or without array formulas, helper columns etc.

I've attached an example file showing my current lookup formula and also the desired result.

Hi there, Thanks for the replies.

Is there any way it can be by the date: So if any ID is received for a given date, all the IDs for that date are received.

So in the attached image:
The ID's for 02/07/2021 should remain "no" because none of them are received.

For 09/07/2021, because ID #4 is received, all the ID's for 09/07/2021 should show "YES".

I'm sorry. I've screwed up the example.

So, I'm looking up the ID not the date.
So going back to the image ID #4 on 09/07/2021. If that ID is found anywhere on the Received sheet, then all the entries for 09/07/2021 should be received.
That's where I was getting the circular ref.

Here's the revised example.
So verbally the logic is: If an ID is found in Received, then all the other ID's for the same date should also be marked as found.