I have a table with 4 Shift's schedules.
I would like a cell somewhere else on the spreadsheet to to identify which shift is working today.
I tried a few hlookups and vlookups, but I think there are too many layers in this for me to comprehend. Anyone want to take a stab at it?
Book2.xls
Bookmarks