My Excel workbook's purpose is to schedule workers in available time blocks:
![Time Sheet](https://i.stack.imgur.com/arTr4.png)
and return the total number of time blocks allotted to each employee, along with the time block (column header) each employee was assigned to in the Work Overview.
![[](https://i.stack.imgur.com/3OEXn.png)
In the work overview sheet, the column "assigned times" uses the following formula:
=(IFERROR(LOOKUP(A3,Schedule!$B$3:$B$7,Schedule!$B$2:$B$2),"No Job Assigned"))
The goal is to search the column of cells (B3:B7) for the name in cell "A3". When if the name appears in column, the column header is returned to the Roster Sheet, next to their name (Assigned times).