Two Cell Consideration for result

Roster Generator.xlsx All right all, I need help here. In this workbook, I have two sheets in works. The first sheet has a drop down for employee name. Once selected it auto populates the employee number based on the information on sheet two. I have sheet 2 data populate from another department's product. Here is where I need help. When an employee is selected from the drop down menu, I also need to select either position A, B, or A/B. When the employee is selected in addition to the other option, I need the employee end date to auto populate from sheet 2's options. Hope this makes sense and appreciate the help in advance. Any questions let me know.

Ahh, Yes. sorry forgot to mention that part.