Forum Discussion
Simple rostering total hours
Hi, I am in a new job position where I need to roster shiftwork staff. I barely know anything about Excel but I am trying to help out in the position. I would like to improve the Excel Spreadsheet th...
A lookup of the codes seems appropriate, but even that technique allows for multiple options (VLOOKUP, XLOOKUP, MATCH and INDEX). See the attached workbook for some ideas.
Of course, the lookup array (a range, as in the workbook, or an Excel table) does not have to be located on the same worksheet.