this is source data

Handover 2020.xlsx | |||
---|---|---|---|

N | |||

19 | 10 | ||

20 | 840824 | ||

21 | 16 | ||

22 | 840860 | ||

23 | 16 | ||

24 | 840890 | ||

25 | 15 | ||

Schedule Import |

i need a formula that fills the column like this

Handover 2020.xlsx | |||
---|---|---|---|

N | |||

29 | 840824 | ||

30 | 840860 | ||

31 | 840890 | ||

32 | |||

33 | |||

Schedule Import |

again i hope that makes sense.

source data sheet - Schedule Import

sheet where i have formulas to return values - Week 1

TIA