Spreadsheet: 35736d1233344782-if-function-vlookup-issue
Sheet: Hidden data

 | N/A | Name to be searched | N/A | N/A | Column to be searched
 | 2 | anetaeurope | 90 | 163545.07 | 18916.87
 | 3 | [NAME] | 290 | 842890.98 | 79408.1
 | 4 | AnjamKhan | 555 | 1489958.49 | 142702.75
 | 5 | BarrySimmons | 431 | 1424681.47 | 159866.06
 | 6 | carltonyork | 59 | 161455.6 | 11127.89
 | 7 | catherinemills | 5 | 6390.05 | 231.85
 | 8 | [NAME] | 129 | 258193.5 | 19248.77
 | 9 | davideastwood | 534 | 1482679.26 | 139341.69
 | 10 | debbiebolton | 5 | 1658.55 | 0.02
 | 11 | [NAME] | 71 | 206859.4 | 20044.65
 | 12 | DerekRamsaroup | 310 | 1062555.63 | 97635.39
 | 13 | Derekwwtwo | 123 | 432242.58 | 47042.19
 | 14 | DharamPatel | 979 | 4331514.53 | 634289.3
 | 15 | [NAME] | 544 | 2454164.61 | 245431.6
 | 16 | eddietowers | 88 | 249984.98 | 37398.86
 | 17 | emmaeurope | 17 | 42275 | 6511.46
 | 18 | emmawright | 210 | 598994.09 | 50688.87
 | 19 | FahimBaree | 454 | 1687832.17 | 176761
 | 20 | gabiecr | 49 | 131838 | 15128.74
 | 21 | GabieDeeks | 481 | 2060965.02 | 211172.25
 | 22 | garyaizen | 154 | 424448.78 | 37997.35
 | 23 | gatanoparnis | 125 | 354511.09 | 28489.97
 | 24 | geshanbandaranaike | 466 | 1767076.9 | 210841.17
 | 25 | girisharora | 2 | 1152 | 8.4
 | 26 | IsaacLarbi | 8 | 9508.12 | -6.81
 | 27 | [NAME] | 5 | 13398.26 | 1564.31
 | 28 | [NAME] | 419 | 1721898.06 | 147606.4
 | 29 | [NAME] | 130 | 212093.68 | 17325.18
 | 30 | jasoneurope | 106 | 257639.79 | 30226.41
 | 31 | [NAME] | 293 | 918556.52 | 101355.85
 | 32 | jaynehough | 82 | 177693.91 | 13786.07
 | 33 | [NAME] | 333 | 1195604.61 | 170399.67
 | 34 | jitmandalia | 471 | 1835233.2 | 209034.56
 | 35 | joannechandler | 452 | 1235517.46 | 148357.72
 | 36 | JulieCollier | 340 | 1471360.96 | 141081.91
 | 37 | juliecr | 11 | 36478.88 | 3047.03
 | 38 | JustianMerritt | 499 | 2007160.65 | 224247.02
 | 39 | justinamerica | 43 | 86290.12 | 7024.82
 | 40 | [NAME] | 294 | 893834.57 | 70098.2
 | 41 | kalpanavelani | 122 | 381144.54 | 32418.96
 | 42 | khumieeuro | 5 | 10005 | 1826.63
 | 43 | khumienawaz | 262 | 733651.09 | 65974.65
 | 44 | khumieusa | 13 | 32847 | 2768.67
 | 45 | khumieww2 | 3 | 10247 | 1121.92
 | 46 | lisachoo | 35 | 100992.92 | 10845.76
 | 47 | Mariacr | 7 | 29864.05 | 4132.39
 | 48 | [NAME] | 550 | 1511572.6 | 148321.12
 | 49 | MarkCourtney | 318 | 1306649.65 | 125489.48
 | 50 | markcr | 8 | 21384 | 1768.18
 | 51 | MatthewSmith | 555 | 2596791.03 | 220592.24
 | 52 | [NAME] | 325 | 1152199.17 | 122160.18
 | 53 | [NAME] | 1106 | 2269228.13 | 220485.62
 | 54 | [NAME] | 486 | 1824971.02 | 179680.36
 | 55 | nelashpatel | 5 | 4844.95 | 150.51
 | 56 | NitaSamji | 27 | -47920.22 | 20558.84
 | 57 | ParryThakrar | 319 | 1081568.67 | 114758.29
 | 58 | paweljarzebowski | 1 | 3805 | 155.66
 | 59 | PritiPatel | 447 | 2011386.43 | 231536.1
 | 60 | Rachellangley | 81 | 327693.65 | 27818.92
 | 61 | [NAME] | 211 | 439121.32 | 51351.17
 | 62 | sanchezj | 1 | 0 | 0.2
 | 63 | SandraFernandes | 479 | 1453168.9 | 155240.44
 | 64 | SanjuSmith | 355 | 1289086.24 | 111355.34
 | 65 | sarahcr | 16 | 40993.88 | 3677.71
 | 66 | sarahharding | 301 | 1074860.95 | 93525.26
 | 67 | sarahwilson | 2 | 1361 | -10.24
 | 68 | SaraMalin | 38 | 120319.03 | 16207.05
 | 69 | SarojKhera | 6 | 857 | 11.8
 | 70 | SevWright | 216 | 566174.91 | 37737.35
 | 71 | [NAME] | 2 | 1310 | 58.5
 | 72 | shitalpatel | 399 | 1641757.29 | 205738.67
 | 73 | Siegels | 19 | 106879.16 | 12.14
 | 74 | siminfazelpour | 1 | 465 | -1.5
 | 75 | SimonBridgers | 310 | 1103930.27 | 115106.59
 | 76 | simoncr | 6 | 30519.25 | 4225.97
 | 77 | SimonEves | 753 | 3071400.4 | 273166.45
 | 78 | SolomonBruce | 283 | 654433.88 | 72682.78
 | 79 | spencergroves | 5 | 61445 | 5276.1
 | 80 | sydusa | 50 | 105335.57 | 6763.76
 | 81 | victoriashowers | 12 | 32568.38 | 3085.84
 | 82 | vincehainsworth | 105 | 319323.67 | 42973.58
 | 83 | waelsamir | 13 | 40322.24 | 9768.91
 | 84 | wsamir | 355 | 1168105.24 | 211116.8
 | 85 | WWJ | 1 | 332.67 | 0
 | 86 | ZainulSamji | 1 | 475 | 1