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.
Bookmarks