Date range has date in or not (several ranges & not unique ID)

Hello

In sheet "Stamp" I have a list of Users with a date stamp. The same user can have several stamps.
In sheet "RangeResult" I have a list of Users with date ranges. The same user can have several date ranges.

I would like to know if there is a Date Stamp in each given date range for each given user?
And show the result in column D "Yes" or "No".

When I use index match I only tap into the first occurrence. Lookup formulas or MIN/MAX I'm very bad at that too. I've tried the other way as well (to show if the date was yes or no in the range, but I'm also struggling with that).

Thanks a lot in advance for your help!

Un tout grand merci !!!

Just one thing to edit in the formula:

Please Login or Register  to view this content.