Need help coding Lookup Statements

Sample Worksheet.xlsxSample Worksheet.xlsxSample workbook attached.

I am currently using this code, thanks to the help of this board to check against scheduling the same employee in a shift. I have tried in vain to utilize this template to further code the rest of the workbook.

Please Login or Register  to view this content.

Explanations of what I am after included in the very basic attached workbook.

Any help is greatly appreciated.