u/Bradisssa

I asked a question for help setting up a formula to lookup the date, shift and state allocation and retuning the name of the team member covering the shift.
This was the suggested formula.

=LET(

inWeek1, ISNUMBER(XMATCH(E2, $C$11:$I$11)),

dayStates, IF(inWeek1, XLOOKUP(E2, $C$11:$I$11, $C$13:$I$21), XLOOKUP(E2, $C$26:$I$26, $C$28:$I$36)),

employees, OFFSET($B$13, ROW(dayStates)-13, 0, 9, 1),

MAP(E3:E6, LAMBDA(state, XLOOKUP(state, dayStates, employees, ) )))

https://preview.redd.it/gppauwhrhvjh1.png?width=952&format=png&auto=webp&s=985c0331f3b36550997243acb43e891656476927

This covered the first 2 weeks, how do i now amend it. so it covers all future dates, runs through to end of year and into the next year.

Thanks heaps