Index and Match - with 2 criteria AND a date range...

[tylerfutures]

Hello,
I have a doozy here and any and all help is truly appreciated.

I am trying to create an Index and Match function that is looking for 2 criteria - a user ID and a date within a range. I have created this array that is looking for the user ID and the specific date:

=INDEX(Sheet2!$I:$I,MATCH(1,(Sheet2!$F:$F=D4)*(Sheet2!$D:$D=J4),0))

It works fine (the first part is looking for the user ID, D4, and the second is looking for the dates - J4 is the date, Sheet2!$D:$D has the dates it is looking through). What I am finding is the dates in Sheet2!:$D:$D may be a few days before or after. What I'd like to do is create something that allows J4 to either be 7 days before or after and return a value. I also need the first part of the function where it is matching user ID.

Any and all help is appreciated. Thank you!

 

[steve the fish]

You could do this:

=INDEX(Sheet2!$I:$I,MATCH(1,(Sheet2!$F:$F=D4)*(Sheet2!$D:$D>=J4-7)*(Sheet2!$D:$D < J4+8),0))<j4+8),0))< html=""></j4+8),0))<>