Spreadsheet: 35736d1233344782-if-function-vlookup-issue
Sheet: Front sheet

 | DK | 2009-01-01 00:00:00 | Column to be populated
 | No | Staff | EOM
 | No | Webtripper id | 0
 | 001 | WWJ | 0
 | 002 | RahulSharma | 0
 | 003 | RitaSharma | 0
 | 004 | ErrolDaCosta | 0
 | 005 | sarahbenkoff | 0
 | 006 | geshanbandaranaike | 0
 | 007 | SandraFernandes | 0
 | 008 | debbiebolton | 0
 | 009 | Spare | 0
 | 010 | SevWright | 0
 | 011 | MarkCourtney | 0
 | 012 | spencergroves | 0
 | 013 | JustianMerritt | 0
 | 014 | SimonBridgers | 0
 | 015 | victoriahammell | 0
 | 016 | girisharora | 0
 | 017 | Spare | 0
 | 018 | NitaSamji | 0
 | 019 | SarojKhera | 0
 | 020 | IsaacLarbi | 0
 | 021 | CharlesAnsahAyeh | 0
 | 022 | Spare | 0
 | 023 | Rachellangley | 0
 | 024 | DerekRamsaroup | 0
 | 025 | [NAME] | 0
 | 026 | Siegals | 0
 | 027 | Spare | 0
 | 028 | FahimBaree | 0
 | 029 | Spare | 0
 | 030 | [NAME] | 0
 | 031 | Spare | 0
 | 032 | Spare | 0
 | 033 | SaraMalin | 0
 | 034 | Spare | 0
 | 035 | Spare | 0
 | 036 | SolomonBruce | 0
 | 037 | Spare | 0
 | 038 | PeteClinkscales | 0
 | 039 | Spare | 0
 | 040 | lisachoo | 0
 | 041 | ParryThakrar | 0
 | 042 | [NAME] | 0
 | 043 | Spare | 0
 | 044 | [NAME] | 0
 | 045 | AnjamKhan | 0
 | 046 | Spare | 0
 | 047 | [NAME] | 0
 | 048 | [NAME] | 0
 | 049 | Spare | 0
 | 050 | Spare | 0
 | 051 | sanchexj | 0
 | 052 | SanjuSmith | 0
 | 053 | Spare | 0
 | 054 | MatthewSmith | 0
 | 055 | RochelleMoreland | 0
 | 056 | ZainulSamji | 0
 | 057 | [NAME] | 0
 | 058 | Spare | 0
 | 059 | Spare | 0
 | 060 | alevgoksu | 0
 | 061 | Spare | 0
 | 062 | joannechandler | 0
 | 063 | Spare | 0
 | 064 | [NAME] | 0
 | 065 | michaeltheobalds | 0
 | 066 | JonathonGilbert | 0
 | 067 | BarrySimmons | 0
 | 068 | vincehainsworth | 0
 | 069 | Spare | 0
 | 070 | Spare | 0
 | 071 | [NAME] | 0
 | 072 | [NAME] | 0
 | 073 | RosalindMack | 0
 | 074 | sarahharding | 0
 | 075 | [NAME] | 0
 | 076 | eddietowers | 0
 | 077 | Spare | 0
 | 078 | Spare | 0
 | 079 | DharamPatel | 0
 | 080 | [NAME] | 0
 | 081 | GabieDeeks | 0
 | 082 | Spare | 0
 | 083 | Spare | 0
 | 084 | PritiPatel | 0
 | 085 | Spare | 0
 | 086 | Spare | 0
 | 087 | Spare | 0
 | 088 | WWJWebTeam | 0
 | 089 | shitalpatel | 0
 | 090 | Spare | 0
 | 091 | Spare | 0
 | 092 | wsamir | 0
 | 093 | Spare | 0
 | 094 | jaynehough | 0
 | 095 | JulieCollier | 0
 | 096 | SimonEves | 0
 | 097 | Spare | 0
 | 098 | Spare | 0
 | 099 | jitmandalia | 0
 | 100 | Spare | 0
 | C1 | helenmcphillips | 0
 | C2 | [NAME] | 0
 | [NAME] | wsamir | 0
 | C4 | nickbartlett | 0
 | C5 | khumienawaz | 0
 | C6 | [NAME] | 0
 | C7 | paulfrost | 0
 | C8 | catherinemills | 0
 | C9 | kalpanavelani | 0
 | C10 | andreacyrus | 0
 | C11 | carltonyork | 0
 | C12 | collettesimpson | 0
 | C13 | davideastwood | 0
 | C14 | davidpicton | 0
 | C15 | [NAME] | 0
 | C16 | emmawright | 0
 | C17 | garyaizen | 0
 | C18 | gatanoparnis | 0
 | C19 | paweljarzebowski | 0
 | C20 | Spare | 0
 | Twin id | anetaeurope | 0
 | Twin id | [NAME] | 0
 | Twin id | Derekwwtwo | 0
 | Twin id | gabiecr | 0
 | Twin id | [NAME] | 0
 | Twin id | jasoneurope | 0
 | Twin id | juliecr | 0
 | Twin id | khumieeuro | 0
 | Twin id | khumienawaz | 0
 | Twin id | khumieusa | 0
 | Twin id | khumieww2 | 0
 | Twin id | Mariacr | 0
 | Twin id | markcr | 0
 | Twin id | sarahcr | 0
 | Twin id | simoncr | 0
 | Twin id | sydusa | 0
 | Twin id | waelsamir | 0
 | Twin id | Spare | 0