Finding a date based on a related "Rang" parameter

tamerj1 I reformulate the case, considering some aspects:

 I have two tables connected by the step, I have different orders performed thought a Serie of steps on an assigned date. The date is not organized from min to max, therefore the rang in table 2 is important. Some orders are missing some steps, and some steps are missing a date, which was fill up with the default value “01.01.2000” (e.g. Step D, order 2345). I need to create an End Date based on the next available step in the “Rang” mapped to the step in table 2. For example, the order 2345 follow the rang until the last available step, while the order 4576 jumps the unavailable values and take the next available as “End Date”. I am using the following formula:

End Date = LOOKUPVALUE

(Process[Start Date],

Parameter[Rang], related(Parameter[Rang])+1,

Process[Order], Process[Order],

 Process[Start Date])

Unfortunately, it does not work when the steps in between are missing. Could you please help me find the right formula for this case? Attached is the test data.

Important considerations

-It is important to consider that there are some steps are not considered in the rang (e.g Step B), therefore only the steps with a rang number should be used in the formula.

- In the last step (e.g. Rang 6) the Start Data and the End Data are the same.

TABLE 1

Table 2

Thank you so much, I appreciate your help, I am sorry I did not iclude all the considerations before.