Hi all, Here is my data. Data A has ID with different lines with start and end dates. ID LINE LOSTART LOEND 1 4 11/27/2017 1/17/2018 1 1 12/1/2015 4/1/2016 1 2 4/5/2016 8/16/2016 1 3 8/23/2016 11/14/2016 2 1 6/4/2016 9/18/2016 2 2 9/19/2016 11/11/2016 3 2 5/6/2016 7/17/2016 3 3 7/18/2016 10/3/2016 4 1 11/2/2015 5/30/2016 4 2 5/31/2016 12/28/2016 4 3 4/8/2018 1/9/2019 5 1 4/3/2015 6/4/2015 5 2 6/5/2015 12/27/2015 5 3 8/5/2016 9/7/2016 6 1 10/12/2015 6/2/2016 6 4 11/7/2016 4/20/2017 6 2 6/3/2016 8/27/2016 7 1 6/5/2016 6/15/2016 Here is data B: ID Order 1 7/16/2016 1 10/2/2017 2 7/18/2016 3 7/18/2016 4 7/26/2016 5 7/31/2016 6 7/31/2016 7 5/10/2016   The end result table is below. I am looking for the line by the order date. The rule for the line variable is as follows: Line = the order date is in between LOstart and LOend; This is pretty straight forward. For example: ID#1 row 1: Line 2 falls between LOstart and  LOend. i.e. 7/16/2016 falls between 4/5/2016 and 8/16/2016   When order date is not in between LOstart and LOend, then Line = before the start of next line. For example: ID#1 row 2: order date 10/2/2017 is considered line 3 because it occurs before the beginning of line 4 LOstart date of 11/27/2018. Similarly with ID#5 order date is 7/31/2016 is considered line 2 because it occurs before the beginning of line 3 LOstart date of 8/5/2016   Finally for only 1 order and if this order occurs before LINE 1 then it is considered 0. For Example: ID#7 row 8: Line is considered 0 because the order date of 5/10/2016 occurs before LOSTART date of 6/5/2016. I tried using SQL and only could get partial results.    Row ID Order LINE 1 1 7/16/2016 2 2 1 10/2/2017 3 3 2 7/18/2016 1 4 3 7/18/2016 3 5 4 7/26/2016 2 6 5 7/31/2016 2 7 6 7/31/2016 2 8 7 5/10/2016 0 Thanks a ton! ... View more