Spreadsheet: 475366d1471280202-v-lookup-and-data-validation-excel-forum-example
Sheet: Darlington

 |  | REPS |  | SOLD |  |  |  |  | DEFERRED
SITE | NAME | NAME | TEAM | 8 | 9 | 10 | 11 | 12 | 8 | 9 | 10 | 11 | 12
DARLINGTON | [NAME] | ABythway | DA - ROP Darlington | 2832.32 | 166.32 | 190.2 | 166.32 | 0 | 2162.5198 | 861.1788999999995 | 406.0632 | 382.1832 | 269.8290000000001
DARLINGTON | [NAME] | adam.hahn | BR - Digital | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
DARLINGTON | ADSDIRECT DA | ADSDIRECTDA | DA - CLS Reception | 303.0300000000001 | 7.21 | 0 | 0 | 0 | 284.03 | 18.99999999999999 | 0 | 0 | 0
DARLINGTON | [NAME] | agrayson | BA - CLS Reception | 288.7000000000002 | 18.56 | 4.3 | 12.88 | 0 | 288.6999999999999 | 18.56 | 4.3 | 12.88 | 0
DARLINGTON | [NAME] | [NAME] | DA Key Accounts & Agencies | 6044.389999999999 | 1012.34 | 39.73 | 141.4 | 0 | 5608.516199999998 | 1586.6462 | 527.9325 | 192.7544 | 0
DARLINGTON | [NAME] | agutteridge | DA - CLS Property | 0 | 0 | 0 | 0 | 0 | 7.252000000000001 | 9.065000000000005 | 7.252000000000003 | 7.252000000000003 | 9.065000000000005
DARLINGTON | [NAME] | [NAME].Pounder | DH - Durham Display Field S | 361.47 | 89.78 | 50.78 | 50.78 | 50.78 | 254.1509 | 126.1636 | 50.77799999999998 | 50.77799999999998 | 63.47249999999997
DARLINGTON | [NAME] | ashleigh.ball | DA - Sales & Service | 1670.179999999999 | 240.27 | 149.99 | 90.89999999999999 | 98.85999999999997 | 1803.3023 | 265.983 | 149.99 | 90.9 | 98.86
DARLINGTON | Amanda Treddenick | atreddenick | DA - ROP Darlington | 1520.31 | 668.4399999999999 | 136.52 | 7.29 | 7.29 | 1613.2729 | 1038.317 | 136.52 | 7.29 | 7.29
DARLINGTON | [NAME] | boakes | DA - Motors Field | 3208.61 | 1818.27 | 411 | 100 | 25 | 3560.6361 | 2105.1267 | 433.918 | 122.918 | 53.6475
DARLINGTON | [NAME] | ccannon | DH - CLS Sales & Services | 0 | 0 | 0 | 0 | 0 | 1.456 | 1.820000000000001 | 0.104 | 0 | 0
DARLINGTON | [NAME] | chall | DA - Motors Tele | 3030.34 | 1411.87 | 200.91 | 100 | 50 | 2708.345300000001 | 1728.649700000001 | 244.7964 | 107.7952 | 59.744
DARLINGTON | [NAME] | Christine.[NAME] | BR - CLS Reader Hols & FC | 191.95 | 7.29 | 0 | 0 | 0 | 191.95 | 7.29 | 0 | 0 | 0
DARLINGTON | [NAME] | [NAME].[NAME] | BR - CLS Reader Hols & FC | 17.02 | 0 | 0 | 0 | 0 | 17.02 | 0 | 0 | 0 | 0
DARLINGTON | [NAME] | [NAME].Pownall | BR - CLS Reader Hols & FC | 6.02 | 0 | 0 | 0 | 0 | 6.02 | 0 | 0 | 0 | 0
DARLINGTON | [NAME] | [NAME].Stone | BR - CLS Sales & Reception | 485.0699999999999 | 0 | 0 | 0 | 0 | 422.9 | 0 | 0 | 0 | 0
DARLINGTON | [NAME] | [NAME] | DH - CLS Sales & Services | 235.86 | 135 | 90.15 | 77.4 | 96.75 | 272.3521 | 138.6365 | 93.0592 | 80.3092 | 100.3865
DARLINGTON | [NAME] | crose | DA - Sales & Service | 82.85999999999997 | 0 | 0 | 0 | 0 | 82.86 | 0 | 0 | 0 | 0
DARLINGTON | [NAME] | cstones | DA - Sales & Service | 1763.400000000005 | 281.02 | 20.19 | 0 | 0 | 1744.7637 | 349.1302999999999 | 24.79039999999999 | 4.600399999999998 | 5.750499999999997
DARLINGTON | Danielle Green | danielle.green | DA - ROP Darlington | 26.95 | 0 | 0 | 0 | 0 | 44.43519999999999 | 0 | 0 | 0 | 0
DARLINGTON | [NAME] | dbriggs | DA - Sales & Service | 2679.369999999997 | 817.1000000000004 | 79.75 | 22.32 | 0 | 2052.0674 | 1010.943500000001 | 426.1580999999999 | 134.0376 | 114.856
DARLINGTON | [NAME] | [NAME].[NAME] | DA - Features ROP | 0 | 0 | 0 | 0 | 0 | 146.2132 | 41.666 | 0 | 0 | 0
DARLINGTON | Gemma Dolan | gdolan | DH - CLS Ents & Hols | 0 | 0 | 0 | 0 | 0 | 8.7248 | 10.906 | 8.724800000000004 | 8.343300000000003 | 8.998500000000002
DARLINGTON | Gemma Wykes | gwykes | DA Business & Ind. ROP | 1665.53 | 1378.71 | 0 | 0 | 0 | 2712.7741 | 1420.5906 | 668.9255999999998 | 0 | 0
DARLINGTON | [NAME] | hbailey | DA - ROP Darlington | 2540.319999999999 | 215 | 0 | 0 | 0 | 2494.8244 | 1030.731 | 95.57800000000002 | 2.245600000000001 | 2.807000000000001
DARLINGTON | Hitesh Mistry | HMistry | DA - CLS Reception | 0 | 0 | 0 | 180 | 0 | 0 | 0 | 0 | 146.6659999999999 | 33.33300000000001
DARLINGTON | Jon Dougherty | [NAME] | DH - CLS Sales & Services | 0 | 0 | 0 | 0 | 0 | 1.1393 | 0 | 0 | 0 | 0
DARLINGTON | [NAME] | jherriman | DA Business & Ind. ROP | 2660.58 | 0 | 0 | 0 | 0 | 3573.647499999998 | 1886.5536 | 212.7999999999999 | 212.7999999999999 | 76
DARLINGTON | Janice Mason | [NAME] | DH - CLS Ents & Hols | 1670.7 | 22.19 | 0 | 0 | 0 | 1478.591800000001 | 608.1915 | 5.916800000000001 | 0 | 0
DARLINGTON | [NAME] | [NAME] | DA - Sales & Service | 654.02 | 13 | 0 | 0 | 0 | 1339.6383 | 74.714 | 0 | 0 | 0
DARLINGTON | [NAME] | joanna.hodgson | DA - Ents & Holidays | 0 | 0 | 0 | 0 | 0 | 2.405200000000001 | 3.006500000000002 | 2.405200000000001 | 2.405200000000001 | 3.006500000000002
DARLINGTON | [NAME] | jwatson | DA - Ents & Holidays | 4044.9 | 538.22 | 15 | 0 | 0 | 4637.505399999999 | 1152.0589 | 18.4462 | 0 | 0
DARLINGTON | [NAME] | kjohns | DA - Sales & Service | 1314.64 | 159.25 | 0 | 0 | 0 | 1318.0818 | 118.8525 | 3.681999999999999 | 3.681999999999999 | 4.602499999999999
DARLINGTON | [NAME] | [NAME] | DH - CLS Ents & Hols | 0 | 0 | 0 | 0 | 0 | 26.70079999999999 | 33.37599999999994 | 25.56779999999996 | 25.25879999999996 | 7.216799999999998
DARLINGTON | [NAME] | lclavery | DH - CLS Ents & Hols | 0 | 0 | 0 | 0 | 0 | 39.172 | 47.62820000000002 | 37.61240000000001 | 33.18490000000001 | 16.023
DARLINGTON | [NAME] | lmiller | DA - Features ROP | 1993.59 | 124.93 | 111.31 | 15 | 0 | 1039.3592 | 1101.4034 | 272.5779000000001 | 66.1637 | 18.7285
DARLINGTON | Lyndsey Mills | lmills | DA - Ents & Holidays | 1366.049999999998 | 44.14999999999999 | 7.319999999999997 | 7.319999999999996 | 3.96 | 1691.1169 | 171.4663 | 7.319999999999996 | 7.319999999999998 | 3.96
DARLINGTON | [NAME] | lstenger | DA - Ents & Holidays | 0 | 0 | 0 | 0 | 0 | 1.192 | 0 | 0 | 0 | 0
DARLINGTON | [NAME] | lucy.smith | DH - Durham Display Field S | 165 | 15 | 0 | 0 | 0 | 165 | 15 | 0 | 0 | 0
DARLINGTON | [NAME] | [NAME].Ward | BR - CLS Sales & Reception | 337.66 | 0 | 0 | 0 | 0 | 337.66 | 0 | 0 | 0 | 0
DARLINGTON | [NAME] | Lydia.[NAME] | BR - CLS Sales & Reception | 1067.1 | 17.46 | 0 | 0 | 0 | 1053.62 | 12.04 | 0 | 0 | 0
DARLINGTON | May Humble | May.Humble | DH - CLS Ents & Hols | 136.55 | 0 | 0 | 0 | 0 | 375.4798 | 0 | 0 | 0 | 0
DARLINGTON | [NAME] | mfielding | DA - ROP Darlington | 0 | 0 | 0 | 0 | 0 | 15.912 | 0 | 0 | 0 | 0
DARLINGTON | [NAME] | Michelle.Boyes | BR - CLS Sales & Reception | 965.1999999999994 | 0 | 0 | 0 | 0 | 965.2 | 0 | 0 | 0 | 0
DARLINGTON | [NAME] | mpinsent | DA - ROP Darlington | 1182.64 | 734.8399999999999 | 61.02 | 20.02 | 370.02 | 1709.4481 | 1172.3099 | 73.9 | 20.02 | 370.02
DARLINGTON | [NAME] | [NAME] | DA - CLS Property | 2737.910000000001 | 400.9400000000001 | 0 | 0 | 0 | 2419.398900000001 | 936.6516000000009 | 158.0628000000001 | 129.8373 | 0
DARLINGTON | [NAME] | palexander | DH - Durham Display Field S | 2676.47 | 1044.64 | 0 | 0 | 0 | 3201.227 | 1300.371 | 120.8232 | 7.300800000000004 | 0
DARLINGTON | [NAME] | phartley | DA - Motors Tele | 265.2099999999998 | 32.07 | 0 | 0 | 0 | 301.8332 | 93.1689 | 7.593600000000006 | 7.593600000000006 | 9.492000000000008
DARLINGTON | [NAME] | rpostgate | DA - Sales & Service | 2704.269999999999 | 1942.93 | 77.16 | 30 | 30 | 2765.141300000001 | 1962.0786 | 344.3558000000001 | 34.2872 | 30
DARLINGTON | [NAME] | Sammi.[NAME] | BR - CLS Reception | 99.17999999999999 | 0 | 0 | 0 | 0 | 99.18 | 0 | 0 | 0 | 0
DARLINGTON | [NAME] | sarah.taylor | DH - Durham Display Field S | 1987.11 | 212 | 0 | 0 | 0 | 1719.9099 | 378.2053000000001 | 5.7512 | 5.7512 | 7.189
DARLINGTON | [NAME] | sdean | DA - Sales & Service | 758.2399999999986 | 219.46 | 175.56 | 175.56 | 418.8800000000002 | 615.6075999999998 | 385.6698 | 175.56 | 175.5599999999999 | 418.8795999999999
DARLINGTON | [NAME] | shall | DH - Durham Display Field S | 2797.74 | 720.85 | 174.34 | 106 | 0 | 2791.381599999999 | 1533.9937 | 266.3339 | 124.6022 | 1.897000000000001
DARLINGTON | [NAME] | sharron.phillips | DA - ROP Darlington | 2261.22 | 377.75 | 0 | 0 | 0 | 2752.848100000001 | 972.2486000000001 | 86.66599999999998 | 0 | 0
DARLINGTON | [NAME] | shirley.mccarthy | DH - CLS Sales & Services | 1667.45 | 23.4 | 0 | 0 | 0 | 1629.1747 | 80.8049 | 0 | 0 | 0
DARLINGTON | Sophie Vickers | Sophie.Vickers | BR - CLS Reader Hols & FC | 424.9300000000001 | 0 | 0 | 0 | 0 | 424.93 | 0 | 0 | 0 | 0
DARLINGTON | [NAME] | sshaw | DA - Ents & Holidays | 0 | 0 | 0 | 0 | 0 | 1.355 | 0 | 0 | 0 | 0
DARLINGTON | [NAME] | Sue.Mayman | YK-ROP York Retail | 98.57 | 0 | 0 | 0 | 0 | 98.5684 | 63.36539999999999 | 0 | 0 | 0
DARLINGTON | [NAME] | [NAME].Turner | BR - CLS Reader Hols & FC | 265.1899999999999 | 0 | 8.1 | 0 | 0 | 255.96 | 0 | 8.1 | 0 | 0
DARLINGTON | [NAME] | swilkinson | DH - CLS Sales & Services | 632.7600000000003 | 72.60000000000005 | 0.59 | 0 | 0 | 723.7583 | 198.2656999999999 | 0.59 | 0 | 0
DARLINGTON | Teresa Curry | tcurry | DH - Durham Display Field S | 4412.759999999999 | 802.67 | 75.33 | 0 | 0 | 4381.427699999999 | 1628.0982 | 87.9734 | 48.42540000000001 | 0
DARLINGTON | [NAME] | tdinsdale | DA - CLS Reception | 257.36 | 7.79 | 0 | 0 | 0 | 236.72 | 7.79 | 0 | 0 | 0
DARLINGTON | [NAME] | Theresa.Mahoney | DA - Motors Field | 3740.29 | 728.85 | 285 | 0 | 0 | 3742.390600000001 | 2209.692400000003 | 285 | 0 | 0
DARLINGTON | Teresa Smurthwaite | tsmurthwaite | DA - Motors Field | 1464.5 | 1839.999999999999 | 306.5 | 0 | 0 | 1464.5 | 1840 | 306.5000000000001 | 0 | 0
DARLINGTON | [NAME] | Usman.[NAME] | BR - CLS Sales & Reception | 1422.550000000001 | 13.74 | 0 | 0 | 0 | 1378.82 | 4.3 | 0 | 0 | 0
DARLINGTON | [NAME] | Viktoria.Smith | DA - ROP Darlington | 129.55 | 0 | 0 | 0 | 0 | 86.70139999999999 | 42.8484 | 0 | 0 | 0
DARLINGTON | [NAME] | vspencer | DA Business & Ind. ROP | 1451 | 1799.86 | 0 | 0 | 0 | 1504.0566 | 1210.0856 | 814.9388 | 15.4929 | 0