Spreadsheet: 773468d1647875245-vlookup-returning-0-and-n-a-help4
Sheet: Scan Data

 |  |  |  | 3
district_description | site_name | claimant_key | Days_in_IWS | IF YES THEN NO FURTHER ACTION IS REQUIRED |  |  |  |  |  | Phone Claim? (Y/N) | Date Commitment Review booked for (DD/MM/YYYYY) | FTA Commitment Review? (Y/N) | [NAME] new appointment booked? (Y/N) | Referred to DM for FTA Commitment Review? (Y/N) | DM Decision to Allow (no sanction) and new appointment booked? (Y/N) | DM Decision to Disallow (sanction imposed)? (Y/N) | Commitment Review attended & CC revised? (Y/N) | CC Accepted (Y/N) | Was revised CC not accepted and Claim Closure action taken? (Y/N) | Notes (for local use)
 |  |  | 1 | Is the claim excluded due to Fraud action ongoing? (Y/N) | Is the claim excluded due to outstanding action not being taken on a previous FTA?  (Y/N) | Is the claim excluded due to no longer being in IWS? (Y/N) | Is the claim excluded due to being closed? (Y/N) | Is the claim excluded because there is an existing open-ended sanction in place for a previous FTA? (Y/N)? | Is the claim excluded due to a tailored commitment already being in place since moving to IWS? (Y/N)
West London | [NAME] | 00722b58-b93a-4155-bccf-f244b22a9549 | 61-90 Days in IWS
West London | [NAME] | 009f4ce2-28ca-406a-9dab-05684903e415 | 0-30 Days in IWS |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Y
West London | [NAME] | 00dbf342-26c9-4e3e-bba2-1e291235da7d | 0-30 Days in IWS |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | N
West London | [NAME] | 010d3940-eec8-4f60-88d3-f911d375a37b | 61-90 Days in IWS
West London | [NAME] | 01198cce-8643-4e65-8011-16c08e6ff740 | 91+ Days in IWS
West London | [NAME] | 022570d3-e6a9-4004-803f-2c021410223d | 31-60 Days in IWS
West London | [NAME] | 03842ca1-fc2d-45a4-90a4-15e2f9915a39 | 91+ Days in IWS
West London | [NAME] | 058889e8-4314-468e-87fa-1d0c9dcf43b9 | 0-30 Days in IWS
West London | [NAME] | 05df38ab-639e-43a7-91e7-3a8f6059d9e3 | 91+ Days in IWS
West London | [NAME] | 0730bf45-e2d0-469d-88f5-a555d7891d6d | 91+ Days in IWS
West London | [NAME] | 074aa154-feb3-4ebb-85d8-ccc587a0452d | 91+ Days in IWS
West London | [NAME] | [NAME]-88ff-114aaf3053fa | 0-30 Days in IWS
West London | [NAME] | 09aa6248-8756-4131-9e53-ee2588b87faa | 0-30 Days in IWS
West London | [NAME] | 0bf8e177-498e-40f2-b4a2-256f710a10f5 | 0-30 Days in IWS
West London | [NAME] | 0ce5075a-fa02-44b0-ad31-7fe464de57ed | 91+ Days in IWS
West London | [NAME] | 0e509ced-ac0f-474a-9ac7-2da411dcced4 | 61-90 Days in IWS
West London | [NAME] | 0f3cf1bb-3f76-4f00-8630-c6a1c3f57f90 | 0-30 Days in IWS
West London | [NAME] | 0fd0b8c0-833d-4eb4-8c37-d0fb6a73f2f8 | 0-30 Days in IWS
West London | [NAME] | 0ff37133-72b4-43df-a7e3-05d0678cb66b | 0-30 Days in IWS
West London | [NAME] | 103d8c98-5a5a-49ea-bcae-8878e07dab09 | 0-30 Days in IWS
West London | [NAME] | 10575ef2-80b8-4da9-967e-8853ec5cb0c1 | 31-60 Days in IWS
West London | [NAME] | 11517d7d-67dc-42eb-bc18-7b43d2c8d5d6 | 91+ Days in IWS
West London | [NAME] | 131e53ee-1186-4c20-a147-aae9f2019da5 | 91+ Days in IWS
West London | [NAME] | 144f0f4c-dfcc-43bc-abdd-c35004204fff | 91+ Days in IWS
West London | [NAME] | 14bc48ae-65c6-433d-8655-3ec790236a17 | 0-30 Days in IWS
West London | [NAME] | 14d0b4f5-1c9e-4c20-a5c6-8cb870d9518a | 0-30 Days in IWS
West London | [NAME] | 1503c4c9-7871-4070-8958-7707535dd793 | 91+ Days in IWS
West London | [NAME] | 1517bcf2-57dc-49df-9a61-71109de870b3 | 0-30 Days in IWS
West London | [NAME] | 17031d0d-1595-4737-ab1d-399a130af050 | 0-30 Days in IWS