Using a VLOOKUP and IF statement inside an IF statement

I'm trying to use an if statement to do a vlookup to verify data on a different worksheet and then use another if statement to perform an equation based on the verification. Here is what I have tried and I get either #NA, #Name, or #Value errors. The reason for this is the separate overtime hours from regular hours only if the person is hourly, not salary. I'm trying the formula in the Thursday worksheet in the Overtime Hours column (BC).

=if(vlookup("hourly", Employees,3,false),if(BB5>8,BB5-8),0)
=if(vlookup("hourly", Employees,3,false),if(BB5>8,BB5-8,0)
=if(vlookup(C3:C12,Employees,3,)="hourly",BB5-8,0)
=if(BB5>8(vlookup("hourly",Employees,3,false), BB5-8,0)

I've also tried all of these with "salaried" in the equation instead of "hourly". Any help would be greatly appreciated. I've been working on this for 2 days

Maybe:

=IF(VLOOKUP($A5,Employees,3,False)="hours",IF(BB5>8,BB5-8,0))


Regards