Return subsequent values within date range

[DerekWooley]

Hello, I have a gantt chart where I am trying to return all item #s , andstart and end dates that correspond to them where the start date is within my minimumand maximum date range for each machine. I would like to return them in orderso they are ascending start and end dates.


My min date is 7/16/2018 in cell A2 and my max date is 10/1/2018 in cell A3.My lookup data table is below as well.



[TABLE="width: 278"]
<tbody>[TR]
[TD="width: 67, bgcolor: transparent"] Column A
[/TD]
[TD="width: 101, bgcolor: transparent"] Column B
[/TD]
[TD="width: 101, bgcolor: transparent"] Column C
[/TD]
[TD="width: 101, bgcolor: transparent"] Column D
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"] Machine:
[/TD]
[TD="bgcolor: transparent"] Item
[/TD]
[TD="bgcolor: transparent"] Start Date
[/TD]
[TD="bgcolor: transparent"] End Date
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"] Machine 1
[/TD]
[TD="bgcolor: transparent"] Formula needed
[/TD]
[TD="bgcolor: transparent"] Formula needed
[/TD]
[TD="bgcolor: transparent"] Formula needed
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"] Machine 1
[/TD]
[TD="bgcolor: transparent"] Formula needed
[/TD]
[TD="bgcolor: transparent"] Formula needed
[/TD]
[TD="bgcolor: transparent"] Formula needed
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"] Machine 1
[/TD]
[TD="bgcolor: transparent"] Formula needed
[/TD]
[TD="bgcolor: transparent"] Formula needed
[/TD]
[TD="bgcolor: transparent"] Formula needed
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"] Machine 2
[/TD]
[TD="bgcolor: transparent"] Formula needed
[/TD]
[TD="bgcolor: transparent"] Formula needed
[/TD]
[TD="bgcolor: transparent"] Formula needed
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"] Machine 2
[/TD]
[TD="bgcolor: transparent"] Formula needed
[/TD]
[TD="bgcolor: transparent"] Formula needed
[/TD]
[TD="bgcolor: transparent"] Formula needed
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"] Machine 2
[/TD]
[TD="bgcolor: transparent"] Formula needed
[/TD]
[TD="bgcolor: transparent"] Formula needed
[/TD]
[TD="bgcolor: transparent"] Formula needed
[/TD]
[/TR]
</tbody>[/TABLE]

[TABLE="width: 278"]
<tbody>[TR]
[TD="width: 168, bgcolor: transparent, colspan: 2"] Look Up data table:
[/TD]
[TD="width: 101, bgcolor: transparent"][/TD]
[TD="width: 101, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"] Column A
[/TD]
[TD="bgcolor: transparent"] Column B
[/TD]
[TD="bgcolor: transparent"] Column C
[/TD]
[TD="bgcolor: transparent"] Column D
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"] Machine:
[/TD]
[TD="bgcolor: transparent"] Item
[/TD]
[TD="bgcolor: transparent"] Start Date
[/TD]
[TD="bgcolor: transparent"] End Date
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"] Machine 1
[/TD]
[TD="bgcolor: transparent"] 235
[/TD]
[TD="bgcolor: transparent"] 7/13/2018
[/TD]
[TD="bgcolor: transparent"] 7/20/2018
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"] Machine 1
[/TD]
[TD="bgcolor: transparent"] 3495
[/TD]
[TD="bgcolor: transparent"] 7/21/2018
[/TD]
[TD="bgcolor: transparent"] 7/25/2018
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"] Machine 1
[/TD]
[TD="bgcolor: transparent"] 2934
[/TD]
[TD="bgcolor: transparent"] 7/26/2018
[/TD]
[TD="bgcolor: transparent"] 7/30/2018
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"] Machine 1
[/TD]
[TD="bgcolor: transparent"] 30467
[/TD]
[TD="bgcolor: transparent"] 7/31/2018
[/TD]
[TD="bgcolor: transparent"] 8/4/2018
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]
[/TD]
[TD="bgcolor: transparent"]
[/TD]
[TD="bgcolor: transparent"]
[/TD]
[TD="bgcolor: transparent"]
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"] Machine 2
[/TD]
[TD="bgcolor: transparent"] 20946
[/TD]
[TD="bgcolor: transparent"] 7/15/2018
[/TD]
[TD="bgcolor: transparent"] 7/20/2018
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"] Machine 2
[/TD]
[TD="bgcolor: transparent"] 29
[/TD]
[TD="bgcolor: transparent"] 7/21/2018
[/TD]
[TD="bgcolor: transparent"] 7/22/2018
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"] Machine 2
[/TD]
[TD="bgcolor: transparent"] 3946
[/TD]
[TD="bgcolor: transparent"] 7/23/2018
[/TD]
[TD="bgcolor: transparent"] 7/28/2018
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"] Machine 2
[/TD]
[TD="bgcolor: transparent"] 2903
[/TD]
[TD="bgcolor: transparent"] 7/29/2018
[/TD]
[TD="bgcolor: transparent"] 7/31/2018
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"] Machine 2
[/TD]
[TD="bgcolor: transparent"] 3021
[/TD]
[TD="bgcolor: transparent"] 8/1/2018
[/TD]
[TD="bgcolor: transparent"] 8/6/2018
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"] Machine 2
[/TD]
[TD="bgcolor: transparent"] 3950
[/TD]
[TD="bgcolor: transparent"] 8/7/2018
[/TD]
[TD="bgcolor: transparent"] 8/10/2018
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"] Machine 2
[/TD]
[TD="bgcolor: transparent"] 4843
[/TD]
[TD="bgcolor: transparent"] 8/11/2018
[/TD]
[TD="bgcolor: transparent"] 8/16/2018
[/TD]
[/TR]
</tbody>[/TABLE]

Thank you for any help.