Is there a way to use LOOKUP VLOOKUP HLOOKUP to return headers in EXCEL Current formula returning wrong value

Question

My Excel workbook's purpose is to schedule workers in available time blocks:

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.

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).

Answer 1

Try this:

=SUMPRODUCT(--(Schedule!$B$3:$F$7=A3))