Part $1$: You work in the Human Resources department for YoyoDyne Propulsion Systems $($YPS$).$ Write a VLOOKUP formula so that when you enter an employee number, the Name, Department and Years on the Job are returned. $(10$ Points$)$

Part $2$: Next construct the a similar formula $($in the next row$),$ but this time so that if an Employee # doesn't exist, the Name will show "Not Found",the Department as "Not Applicable" and Years on Job will be blank if the name does not exist. $(10$ Points$)$