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$)$S

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$)$

Enter Employee # $==>$

$\backslash$table$[[$Employee # Name,Department Years on Job,$],[\frac{-}{{?}_{\frac{?}{?}}}2,$#N$/$A$,$#N$/$A$],[1064,020$ pts possible,$]]$

$\backslash$table$[[$Name$,$Years on Job,Department,Employee #$],[$Artie Duncan,$51,$Manufacturing,$1103],[$Billy Travers,$50$ Operations,$1098,],[$Bob Miller,$5$ MIS,$1017,],[$Emile Lizardo,$8,$R&D$,1037],[$Enrico Fermi,$15,$R&D$,1072],[$Fred White,$7,$Accounting,$1031],[$Jane Doe,$5,$Operations,$1008],[$Jill Young,$8$ Manufacturing,$1035,],[$Joe Montana,$21$ Public Relations,$1076,],[$Joe Smith,$5$ Accounting,$1001,],[$John Bigboote,$9$ Executive,$1046,],[$John Endall,$50$ Manufacturing,$1094,],[$John Gomez,$45$ Operations,$1087,],[$John O$\text{'}$ Connor,$40$ Manufacturing,$1085,],[$John Parker,$39$ Operations,$1084,],[$John Yaya,$9,1038,],[$Lee lacocca,Security,$1080,],[$Professor Hikita,$27,$Executive,$1047],[$Seymour Cray,$10,$R&D$,1083],[$Tom Peters,$33$ MIS,$1064,]]$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$)$S

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$)$

Enter Employee # $==>$

$\backslash$table$[[$Employee # Name,Department Years on Job,$],[\frac{-}{{?}_{\frac{?}{?}}}2,$#N$/$A$,$#N$/$A$],[1064,020$ pts possible,$]]$

$\backslash$table$[[$Name$,$Years on Job,Department,Employee #$],[$Artie Duncan,$51,$Manufacturing,$1103],[$Billy Travers,$50$ Operations,$1098,],[$Bob Miller,$5$ MIS,$1017,],[$Emile Lizardo,$8,$R&D$,1037],[$Enrico Fermi,$15,$R&D$,1072],[$Fred White,$7,$Accounting,$1031],[$Jane Doe,$5,$Operations,$1008],[$Jill Young,$8$ Manufacturing,$1035,],[$Joe Montana,$21$ Public Relations,$1076,],[$Joe Smith,$5$ Accounting,$1001,],[$John Bigboote,$9$ Executive,$1046,],[$John Endall,$50$ Manufacturing,$1094,],[$John Gomez,$45$ Operations,$1087,],[$John O$\text{'}$ Connor,$40$ Manufacturing,$1085,],[$John Parker,$39$ Operations,$1084,],[$John Yaya,$9,1038,],[$Lee lacocca,Security,$1080,],[$Professor Hikita,$27,$Executive,$1047],[$Seymour Cray,$10,$R&D$,1083],[$Tom Peters,$33$ MIS,$1064,]]$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$)$S

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$)$

Enter Employee # $==>$

$\backslash$table$[[$Employee # Name,Department Years on Job,$],[\frac{-}{{?}_{\frac{?}{?}}}2,$#N$/$A$,$#N$/$A$],[1064,020$ pts possible,$]]$

$\backslash$table$[[$Name$,$Years on Job,Department,Employee #$],[$Artie Duncan,$51,$Manufacturing,$1103],[$Billy Travers,$50$ Operations,$1098,],[$Bob Miller,$5$ MIS,$1017,],[$Emile Lizardo,$8,$R&D$,1037],[$Enrico Fermi,$15,$R&D$,1072],[$Fred White,$7,$Accounting,$1031],[$Jane Doe,$5,$Operations,$1008],[$Jill Young,$8$ Manufacturing,$1035,],[$Joe Montana,$21$ Public Relations,$1076,],[$Joe Smith,$5$ Accounting,$1001,],[$John Bigboote,$9$ Executive,$1046,],[$John Endall,$50$ Manufacturing,$1094,],[$John Gomez,$45$ Operations,$1087,],[$John O$\text{'}$ Connor,$40$ Manufacturing,$1085,],[$John Parker,$39$ Operations,$1084,],[$John Yaya,$9,1038,],[$Lee lacocca,Security,$1080,],[$Professor Hikita,$27,$Executive,$1047],[$Seymour Cray,$10,$R&D$,1083],[$Tom Peters,$33$ MIS,$1064,]]$