Hi everyone,

I am attempting to make a formula that will output true or false based on the following:

The formula should first check to see if a date in one sheet falls within a date range on another sheet. If it does fall within that date range, I want it do next check to see if the identifiers for both dates match.

I know this may come out a bit confusing, so I would be happy to clear up anything. Also, if at all possible, it would be great if the output could be the row numbers in which the values are true, instead of just a generic true/false.

Thanks in advance!