Spreadsheet: 35737d1233345347-if-function-vlookup-20issue-1-
Sheet: Front sheet

 | DK | 2009-01-01 00:00:00 | Column to be populated
 | No | Staff | EOM
 | No | Webtripper id
 | 001 | WWJ | 0
 | 002 | RahulSharma
 | 003 | RitaSharma
 | 004 | ErrolDaCosta
 | 005 | sarahbenkoff
 | 006 | geshanbandaranaike | 210841.17
 | 007 | SandraFernandes | 155240.44
 | 008 | debbiebolton | 0.02
 | 009 | Spare
 | 010 | SevWright | 37737.35
 | 011 | MarkCourtney | 125489.48
 | 012 | spencergroves | 5276.1
 | 013 | JustianMerritt | 224247.02
 | 014 | SimonBridgers | 115106.59
 | 015 | victoriahammell
 | 016 | girisharora | 8.4
 | 017 | Spare
 | 018 | NitaSamji | 20558.84
 | 019 | SarojKhera | 11.8
 | 020 | IsaacLarbi | -6.81
 | 021 | CharlesAnsahAyeh
 | 022 | Spare
 | 023 | Rachellangley | 27818.92
 | 024 | DerekRamsaroup | 97635.39
 | 025 | [NAME] | 51351.17
 | 026 | Siegals
 | 027 | Spare
 | 028 | FahimBaree | 176761
 | 029 | Spare
 | 030 | [NAME] | 147606.4
 | 031 | Spare
 | 032 | Spare
 | 033 | SaraMalin | 16207.05
 | 034 | Spare
 | 035 | Spare
 | 036 | SolomonBruce | 72682.78
 | 037 | Spare
 | 038 | PeteClinkscales
 | 039 | Spare
 | 040 | lisachoo | 10845.76
 | 041 | ParryThakrar | 114758.29
 | 042 | [NAME] | 20044.65
 | 043 | Spare
 | 044 | [NAME] | 148321.12
 | 045 | AnjamKhan | 142702.75
 | 046 | Spare
 | 047 | [NAME] | 245431.6
 | 048 | [NAME] | 79408.1
 | 049 | Spare
 | 050 | Spare
 | 051 | sanchexj
 | 052 | SanjuSmith | 111355.34
 | 053 | Spare
 | 054 | MatthewSmith | 220592.24
 | 055 | RochelleMoreland
 | 056 | ZainulSamji | 1
 | 057 | [NAME] | 170399.67
 | 058 | Spare
 | 059 | Spare
 | 060 | alevgoksu
 | 061 | Spare
 | 062 | joannechandler | 148357.72
 | 063 | Spare
 | 064 | [NAME] | 179680.36
 | 065 | michaeltheobalds
 | 066 | JonathonGilbert
 | 067 | BarrySimmons | 159866.06
 | 068 | vincehainsworth | 42973.58
 | 069 | Spare
 | 070 | Spare
 | 071 | [NAME] | 122160.18
 | 072 | [NAME] | 220485.62
 | 073 | RosalindMack
 | 074 | sarahharding | 93525.26
 | 075 | [NAME] | 101355.85
 | 076 | eddietowers | 37398.86
 | 077 | Spare
 | 078 | Spare
 | 079 | DharamPatel | 634289.3
 | 080 | [NAME] | 17325.18
 | 081 | GabieDeeks | 211172.25
 | 082 | Spare
 | 083 | Spare
 | 084 | PritiPatel | 231536.1
 | 085 | Spare
 | 086 | Spare
 | 087 | Spare
 | 088 | WWJWebTeam
 | 089 | shitalpatel | 205738.67
 | 090 | Spare
 | 091 | Spare
 | 092 | wsamir | 211116.8
 | 093 | Spare
 | 094 | jaynehough | 13786.07
 | 095 | JulieCollier | 141081.91
 | 096 | SimonEves | 273166.45
 | 097 | Spare
 | 098 | Spare
 | 099 | jitmandalia | 209034.56
 | 100 | Spare
 | C1 | helenmcphillips
 | C2 | [NAME] | 70098.2
 | [NAME] | wsamir | 211116.8
 | C4 | nickbartlett
 | C5 | khumienawaz | 65974.65
 | C6 | [NAME]
 | C7 | paulfrost
 | C8 | catherinemills | 231.85
 | C9 | kalpanavelani | 32418.96
 | C10 | andreacyrus
 | C11 | carltonyork | 11127.89
 | C12 | collettesimpson
 | C13 | davideastwood | 139341.69
 | C14 | davidpicton
 | C15 | [NAME]
 | C16 | emmawright | 50688.87
 | C17 | garyaizen | 37997.35
 | C18 | gatanoparnis | 28489.97
 | C19 | paweljarzebowski | 155.66
 | C20 | Spare
 | Twin id | anetaeurope | 18916.87
 | Twin id | [NAME] | 19248.77
 | Twin id | Derekwwtwo | 47042.19
 | Twin id | gabiecr | 15128.74
 | Twin id | [NAME] | 1564.31
 | Twin id | jasoneurope | 30226.41
 | Twin id | juliecr | 3047.03
 | Twin id | khumieeuro | 1826.63
 | Twin id | khumienawaz | 65974.65
 | Twin id | khumieusa | 2768.67
 | Twin id | khumieww2 | 1121.92
 | Twin id | Mariacr | 4132.39
 | Twin id | markcr | 1768.18
 | Twin id | sarahcr | 3677.71
 | Twin id | simoncr | 4225.97
 | Twin id | sydusa | 6763.76
 | Twin id | waelsamir | 9768.91
 | Twin id | Spare