Multiple Criteria - Within Date Range and Matching Value Within Row

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!

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

Let me know if this works!

One week before date obtained | =SUM(A2-90) ?

Fixed that. See below

Before Date: 01/10/2014
After Date: 06/01/2015
Measurement Date: 01/03/2015

result : TRUE
are you sure: BD<=MD<=AD ?

date format : mm/dd/yyyy or dd/mm/yyyy ? but I don't think it is important because excel will change format accordingly

Originally Posted by sandy666

Before Date: 01/10/2014
After Date: 06/01/2015
Measurement Date: 01/03/2015

result : TRUE
are you sure: BD<=MD<=AD ?

date format : mm/dd/yyyy or dd/mm/yyyy ? but I don't think it is important because excel will change format accordingly

I apologize, I just created the info and thought I had it right. The date format is month/day/year. And it should be 01/10/15

Originally Posted by ForProse

I want it do next check to see if the identifiers for both dates match.

Both dates?
One is Date of Measurement
Second?

Originally Posted by sandy666

Both dates?
One is Date of Measurement
Second?

The measurement date is 1/10/15, the BD is all of the values within the BD column (similarly for the AD). If it matches between the date range, it should next check to see if the identifiers match, and if it does, it should output TRUE

If I check DM and it is ok, then I can check Idetifiers if they are the same
so I don't understand both dates, sorry

better see attached file on the first sheet (because it was easier to me all on one sheet )
=IF(AND(F2>=B2,F2<=C2,INDEX($G$2:$G$9,MATCH(F2,$F$2:$F$9,0))=J2),MATCH(F2,$F$2:$F$9,0),"") (here is an idiotic match but ...)