=if(or)=indirect(),index(match(countif)) returns 0

[Nazerith]

First cell
=IF(OR(I26,J26)=INDIRECT(C8),INDEX(Name,MATCH(COUNTIF(Sheet20!A3:A19,"utility")-1&Sheet20!C4,Sheet20!A4:A21&time_in,0),INDEX(Name,MATCH(Sheet20!A4&Sheet20!C4,Sheet20!A4:A21&time_in,0))))

I26+H26 are merged cells

C8 ia one of the names in the Names list

Second cell
Utility K26

Third Cell
=indirect(I26) indirect(K26) inserted into cell L26

all data is on Sheet 20


This returns 0


translation
if, (the contents of cell I26 contain cell C8 contents, find the Name for the next person that has the job "utility" from sheet 20 and link it with the name associated with that jobcode to the box left of "utility", and once you have the name and job code find Time_in that coincides with those 2 and enter them in the box to the left of "utility")