I NEED HELP

  • Thread starter Thread starter MonnD
  • Start date Start date
M

MonnD

I need help figuring out what formula to use if I have an ID# and a date that falls within a range what is the date that corresponds to both those criteria

ID DATE RANGE Date
1956 11/29/2012 2/28/2013 1/13/2013
3000 11/29/2012 2/28/2013 1/13/2013
37999 11/29/2012 2/28/2013 1/13/2013
3609 11/29/2012 2/28/2013 1/13/2013
20057 11/29/2012 2/28/2013 1/13/2013
4140 11/30/2012 3/1/2013 1/14/2013
4143 11/30/2012 3/1/2013 1/14/2013

# 3000
Date 12/2/2012
Response:
 
=IF(AND(B11>INDEX(A2:D8;MATCH(B10;A2:A8;0);2);B11<INDEX(A2:D8;MATCH(B10;A2:A8;0);3));INDEX(A2:D8;MATCH(B10;A2:A8;0);4);0)

column A = ID#
column B = first date of date range
column C = last date of date range
column D = return date

cell B10 = ID#
cell B11 = Date

Hope this helps.
 
Back
Top