I have a spreadsheet (attached) where I have a rota for all colleagues by week and then a daily tab which will separate out the names into their department.
I need to have a formula on the 2nd tab (in the highlighted red box) to look up the next person who works in that department that is due in from the rota on the other tab and return the name.
Hope that makes sense and this is an easy fix that I just cannot see
Thanks again for you help
Bookmarks