I am trying to create a formula that will automatically tell me which crew is working on a particular day and shift. I have tried several things from many different forums but somehow I am not doing something correct.
This worksheet is very large and I do not want to create new tables or additional columns if at all possible.