Spreadsheet: 61700d1262633584-vlookup-reporting-n-a-in-some-instances-and-not-in-others-for-same-information-sample-workbook
Sheet: Sheet2

Code | Position
100110 | General Manager
100111 | Asst. General Manager
100120 | Night Manager
100150 | Exec. [NAME]
105050 | Interns
108010 | Dir of Human Resources
108020 | Human Resources Manaer
108050 | Human Resources Asst.
108510 | Director of Finance
108511 | [NAME] of Finance
108521 | [NAME]
108550 | Accounting Clerk
108560 | Accounts Rec/Pay
108565 | General [NAME]
109510 | Director of IT
109520 | IT Manager
109820 | Security Manager
109850 | Security Attendant
109880 | Condo Security
200110 | Dir. of Housekeeping
200111 | Asst. Dir of Housekeeping
200120 | Housekeeping Manager
200150 | [NAME] Assistant
201030 | [NAME]
201050 | Room Attendant
201055 | House Attendant
202030 | Public Area Supervisor
202050 | Public Area Attendant
202055 | [NAME]
203030 | Laundry Supervisor
203040 | LaundLead
203050 | [NAME]
205050 | Bell Staff
208030 | Condo Floor Supervisor
208050 | Condo Room Attendant
208055 | [NAME] Attendant
208250 | Condo Public Area Attndnt
208255 | Condo Floor Care Attndant
208350 | [NAME] Attndnt
300110 | Dir of F&B
300111 | [NAME] of F&B
300120 | F&B Manager
300150 | F&B Admin
300155 | F&B Purchasing
300156 | F & B Receiving Agent
301020 | Restaurant 2 Manager
301030 | Restaurant 2 Supervisor
301040 | Restaurant 2 Server Lead
301050 | Restaurant 2 - Server
301051 | Restaurant 2 Host
301052 | Restaurant 2 Busser
301055 | Restaurant 2 Room Service
301099 | Restaurant 2 Svr Training
301120 | Restaurant 1 Manager
301130 | Restaurant 1 Supervisor
301140 | Restaurant 1 Server Lead
301150 | Restaurant 1 - Server
301151 | Restaurant 1 Host
301152 | Restaurant 1 Busser
301155 | Restaurant 1- Rm Service
301199 | Restaurant 1 Server Train
302017 | Restaurant 2 Sous Chef
302040 | Restaurant 2 Culinary Ld
302060 | Restaurant 2 Cook
302065 | Restaurant 2 Dishwasher
302115 | Restaurant 1 Exec Chef
302116 | Restaurant 1 Exec Sous Chf
30211 | Restaurant I Sous Chef
302140 | Restaurant I Culinary Ld
302160 | Restaurant 1 Cook
302162 | Restaurant I [NAME]
302165 | Restaurant 1 Dishwasher
303020 | Snack Bar Manager
303030 | Snack Bar Supervisor
303050 | Snack Bar Attendant
303120 | Water Park Snack Bar Mgr
303150 | Snack Bar Server
303160 | [NAME]
304020 | Confectionary Manager
304030 | Confectionary Supervisor
304050 | [NAME]
304062 | Confectionary [NAME]
307018 | [NAME]
307019 | [NAME]
307020 | Banquet Manager
307030 | Banquet Supervisor
307040 | Banquet Captain
307050 | [NAME]
307055 | [NAME]
307065 | [NAME]
307099 | [NAME]
307150 | Room Service Server
308020 | Pizza Hut Manager
308030 | Pizza Hut Supervisor
308050 | Pizza Hut Attendant
308051 | Pizza Hut Host
308052 | Pizza Hut Busser
308060 | Pizza Hut Cook
308065 | Pizza Hut Aqua Chef
308120 | Coffee Shop Manager
308130 | Coffee Shop Supervisor
308150 | Coffee Shop Staff
308162 | Coffee Shop-Donut Finishe
351020 | Restaurant 2 Bar Manager
351040 | Restaurant 2 Bar Lead
351056 | Restaurant 2 Bartender
351156 | Restaurant 1 Bartender
351250 | F&B - Snack Bar Bartender
357156 | [NAME]
400110 | Dir of Sales & Marketing
400120 | Sales Manager
400121 | Catering Sales Manager
400150 | Sales Coordinator
400151 | Catering Coordinator
400155 | Sales Assistant
400156 | Special Events
500110 | Dir of Aquatics
500111 | [NAME] of Aquatics
500120 | Aquatics Manager
500140 | Aquatics Supervisor
500150 | Lifeguard
502050 | [NAME]
600110 | Dir of Retail Services
600111 | [NAME] of Retail
600120 | [NAME] Manager
600155 | [NAME]
600156 | Retail Inventory Crdinatr
601030 | [NAME] Supervisor
601040 | [NAME]
601050 | [NAME]
601150 | [NAME] WaterPark
601650 | Animaland Associate
601750 | [NAME]
601850 | [NAME]
601930 | Racezone Lead
601950 | Racezone Associate
602020 | Mgr/Event Coordinator
602040 | Tech Center Staff
602050 | Tech Jockey
603020 | Arcade Manager
603030 | [NAME]
603040 | [NAME]
603050 | [NAME]
603120 | MagiQuest Manager
603130 | Magiquest Supervisor
603150 | [NAME]
603350 | [NAME]
603540 | [NAME]
603550 | [NAME]
650110 | Dir of Spa Services
650120 | Spa Manager
650130 | Spa Supervisor
651040 | AVEDA Advisor [NAME]
651041 | [NAME]
651050 | AVEDA Advisor
652040 | Massage Therapist Lead
652050 | Massage Therapist
653040 | Nail Technician Lead
653041 | Spa Hair Stylist
653050 | Nail Technician
654040 | Esthetician Lead
654050 | Esthetician
700101 | Director of Rooms Div
700110 | Dir of Guest Services
700111 | [NAME] of Guest Service
701020 | Guest Services Manager
701030 | Front Desk Supervisor
701050 | Front Desk Agent
701051 | Night Auditor
701052 | Night Audit Supervisor
701053 | Bell Staff
701055 | Concierge
702050 | Reservationist
703020 | Revenue Manager
704050 | PBX Operator
708050 | Condo Front Desk Agent
750110 | Experience Coordinator
751010 | Director of Brand Exp
751050 | Cub Club Guide
751051 | [NAME]
900110 | Dir of Engineering
900111 | [NAME] of Engineering
900120 | Maintenance Manager
900130 | Engineering Supervisor
900131 | Asst Engineering Suprvr
901050 | [NAME]
901055 | [NAME]
902020 | Waterpark Maint Manager
902030 | Waterpark Technician Superv
902050 | Waterpark Technician
902059 | [NAME]