I have one sheet that contains a list of employees and training modules they need to complete. On another sheet, I have a list of the employees and their schedule for the week.
I'd like to make a column on the sheet with training modules that looks up that employee's schedule and gets their next scheduled date and the shift they're working (if they're not working the current day)
I think I just have to use XLOOKUP but I'm struggling wrapping my head around the operations I need to do
See attached sample workbook
Bookmarks