Spreadsheet: 773089d1647612313-nested-if_or-and-vlookup-statement-nested-if_or-and-vlookup-statement
Sheet: Raw Data

Candidate Id | Job Region | [NAME] | Rejection Face To Face Reason | Rejection Face To Face Date | Reject No Show Date - Archive | Failed F2f Date - Archive |  | [NAME] |  | [NAME] | Meaning
10411319 | Central East | 0 |  |  |  | 03/03/2022 |  |  |  | 690486 | No Compliance Docs Produced
11174900 | South | 690533 |  | 03/03/2022 |  |  |  |  |  | 690328 | Candidate Not Suitable
11214216 | Central East | 0 |  |  |  | 02/03/2022 |  |  |  | 690329 | Failed Telephone Interview
 |  |  |  |  |  |  |  |  |  | 690335 | Cannot Commit To Shift Patterns
 |  |  |  |  |  |  |  |  |  | 690334 | DBS/RTW Missing
 |  |  |  |  |  |  |  |  |  | 690336 | Doesn't Want To Perform Personal Care
 |  |  |  |  |  |  |  |  |  | 690330 | Duplicate Application
 |  |  |  |  |  |  |  |  |  | 690358 | Found Another Job
 |  |  |  |  |  |  |  |  |  | 690354 | Personal/Health
 |  |  |  |  |  |  |  |  |  | 690333 | Previous Interview No Show
 |  |  |  |  |  |  |  |  |  | 690332 | Role No Longer Available
 |  |  |  |  |  |  |  |  |  | 690350 | TTH - Wait Too Long
 |  |  |  |  |  |  |  |  |  | 690340 | Unable To Contact
 |  |  |  |  |  |  |  |  |  | 690363 | Bad Leaver
 |  |  |  |  |  |  |  |  |  | 690368 | Pay Too Low
 |  |  |  |  |  |  |  |  |  | 653681 | CV/App Form Not Suitable
 |  |  |  |  |  |  |  |  |  | 653592 | Failed Telephone Interview
 |  |  |  |  |  |  |  |  |  | 670722 | Part of Warm List
 |  |  |  |  |  |  |  |  |  | 689240 | [NAME] Issue
 |  |  |  |  |  |  |  |  |  | 653588 | DBS/PVG Failed
 |  |  |  |  |  |  |  |  |  | 653587 | DBS/RTW Missing
 |  |  |  |  |  |  |  |  |  | 653594 | Duplicate Application
 |  |  |  |  |  |  |  |  |  | 654578 | Incomplete Application
 |  |  |  |  |  |  |  |  |  | 680123 | Location Too Far
 |  |  |  |  |  |  |  |  |  | 653591 | No Contact
 |  |  |  |  |  |  |  |  |  | 653677 | Previous Employee
 |  |  |  |  |  |  |  |  |  | 653585 | [NAME]
 |  |  |  |  |  |  |  |  |  | 661678 | Repeated Induction No Show
 |  |  |  |  |  |  |  |  |  | 605300 | Wait Too Long
 |  |  |  |  |  |  |  |  |  | 668252 | Failed Written Exercise
 |  |  |  |  |  |  |  |  |  | 605301 | Role No Longer Available
 |  |  |  |  |  |  |  |  |  | 605302 | Personal/Health
 |  |  |  |  |  |  |  |  |  | 670765 | Previous Interview No Show
 |  |  |  |  |  |  |  |  |  | 605308 | Found Other Job
 |  |  |  |  |  |  |  |  |  | 605309 | No Longer Interested
 |  |  |  |  |  |  |  |  |  | 690337 | Part Of Warm List
 |  |  |  |  |  |  |  |  |  | 690349 | No Compliance Docs Produced
 |  |  |  |  |  |  |  |  |  | 690339 | Failed LLN Assessment
 |  |  |  |  |  |  |  |  |  | 690359 | Found Another Job
 |  |  |  |  |  |  |  |  |  | 690355 | Personal/Health
 |  |  |  |  |  |  |  |  |  | 690338 | Services Too Far
 |  |  |  |  |  |  |  |  |  | 690351 | TTH - Wait Too Long
 |  |  |  |  |  |  |  |  |  | 690341 | Unable To Contact
 |  |  |  |  |  |  |  |  |  | 690367 | Pay Too Low
 |  |  |  |  |  |  |  |  |  | 690348 | DBS/PVG Failed
 |  |  |  |  |  |  |  |  |  | 690360 | Found Another Job
 |  |  |  |  |  |  |  |  |  | 690356 | Personal/Health
 |  |  |  |  |  |  |  |  |  | 690345 | [NAME]
 |  |  |  |  |  |  |  |  |  | 690347 | Repeated Induction No Show
 |  |  |  |  |  |  |  |  |  | 690352 | TTH - Wait Too Long
 |  |  |  |  |  |  |  |  |  | 690344 | Unable To Contact
 |  |  |  |  |  |  |  |  |  | 690364 | Failed Health Assessment
 |  |  |  |  |  |  |  |  |  | 690366 | Pay Too Low
 |  |  |  |  |  |  |  |  |  | 690361 | Found Another Job
 |  |  |  |  |  |  |  |  |  | 690357 | Personal/Health
 |  |  |  |  |  |  |  |  |  | 690346 | Repeated Induction No Show
 |  |  |  |  |  |  |  |  |  | 690353 | TTH - Wait Too Long
 |  |  |  |  |  |  |  |  |  | 690343 | Unable To Contact
 |  |  |  |  |  |  |  |  |  | 690365 | Pay Too Low
 |  |  |  |  |  |  |  |  |  | 690507 | Failed Face to Face Interview
 |  |  |  |  |  |  |  |  |  | 690508 | No Show At Interview
 |  |  |  |  |  |  |  |  |  | 690533 | Part Of Warm List
 |  |  |  |  |  |  |  |  |  | 0 | No Reason Given