Spreadsheet: 826765d1682255452-help-with-lookup-function-table-example
Sheet: Sheet1

Tag | Row | Tree | Type | Longitude | Latitude | [NAME] 16/6/21 | Cherry count 1/12/21 | FBC 21.4.22 | FBC recount 25.4.22 | Expected | FBC Sept 22 | Cherry count 9.11.22 | Cherry 14.12.22 | Difference
1 | 2 | 18 | Lapin | [PHONE] | -44.9230253 | 41 | 48 | 43 | 50 | 120.4 |  | 65 | 94
2 | 2 | 58 | Lapin | [PHONE] | -44.92221423 | 50 | 42 | 225 | 300 | 630 |  | 530 | 556
3 | 3 | 54 | Lapin | [PHONE] | -44.92230792 | 15 | 31 | 52 | 96 | 145.6 |  | 140 | 176
4 | 3 | 84 | Lapin | [PHONE] | -44.92169189 | 19 | 20 | 43 | 94 | 120.4 |  | 90 | 103
5 | 4 | 39 | Lapin | [PHONE] | -44.92262295 | 22 |  | 47 | 96 | 131.6 | 88 | 150 | 199
6 | 4 | 75 | Lapin | [PHONE] | -44.92189343 | 14 | 10 | 12 | 38 | 33.6 |  | 40 | 51
7 | 5 | 35 | Lapin | [PHONE] | -44.92271659 | 119 | 250 | 215 | 223 | 602 |  | 200 | 537
8 | 6 | 32 | Lapin | [PHONE] | -44.9227888 | 29 | 38 | 50 | 79 | 140 |  | 100 | 173
9 | 6 | 34 | Lapin | [PHONE] | -44.92274827 | 39 | 70 | 122 | 97 | 341.6 |  | 210 | 311
10 | 6 | 62 | Lapin | [PHONE] | -44.92218087 | 20 | 100 | 8 | 22 | 22.4 |  | 35 | 61
11 | 6 | 85 | Lapin | 169.287251 | -44.92153931 | 35 | 28 | 60 | 60 | 168 |  | 90 | 114
12 | 9 | 23 | Lapin | [PHONE] | -44.92300591 | 26 | 30 | 21 | 39 | 58.8 |  | 70 | 67
13 | 10 | 67 | Lapin | [PHONE] | -44.92212513 | 17 | 32 | 47 | 49 | 131.6 |  | 70 | 108
14 | 11 | 43 | sweetheart | [PHONE] | -44.92262242 | 13 | 25 | 12 | 10 | 33.6 |  | 2 | 4
15 | 11 | 56 | sweetheart | [PHONE] | -44.92235945 | 53 | 24 | 62 | 80 | 173.6 |  | 50 | 46
16 | 11 | 83 | sweetheart | [PHONE] | -44.92181328 | 7 | 0 | 68 | 126 | 190.4 |  | 45 | 55
17 | 12 | 47 | sweetheart | [PHONE] | -44.92255427 | 19 | 22 | 36 | 41 | 100.8 |  | 9 | 22
18 | 13 | 15 | sweetheart | 169.285954 | -44.92321525 | 74 | 108 | 182 | 227 | 509.6 |  | 260 | 380
19 | 16 | 32 | sweetheart | [PHONE] | -44.92290643 | 45 | 55 | 89 | 101 | 249.2 |  | 110
20 | 16 | 67 | sweetheart | [PHONE] | -44.92219674 | 18 | 18 | 71 | 130 | 198.8 |  | 70 | 103
21 | 17 | 59 | sweetheart | [PHONE] | -44.92237095 | 26 | 9 | 62 | 118 | 173.6 |  | 105 | 137
22 | 17 | 82 | sweetheart | [PHONE] | -44.92190458 | 38 | 13 | 19 | 22 | 53.2 | 40 | 11 | 19
23 | 18 | 27 | sweetheart | [PHONE] | -44.92303049 | 41 | 1 | 23 | 15 | 64.4 |  | 0 | 0
24 | 19 | 24 | sentennial | [PHONE] | -44.92310392 | 6 | 0 |  | 21 | 0 |  | 1 | 1
25 | 19 | 62 | sentennial | [PHONE] | -44.92233386 | 5 | 0 | 35 | 41 | 98 |  | 3 | 8
26 | 19 | 83 | sentennial | [PHONE] | -44.92190831 | 2 | 1 | 49 | 79 | 137.2 | 67 | 12 | 10
27 | 20 | 4 | sentennial | [PHONE] | -44.92352217 | 10 | 3 | 19 | 21 | 53.2 |  | 0 | 0
28 | 20 | 27 | sentennial | [PHONE] | -44.92305581 | 5 | 0 | 16 | 19 | 44.8 |  | 2 | 2
29 | 20 | 74 | sentennial | [PHONE] | -44.9221028 | 0 | 0 | 12 | 12 | 33.6 |  | 0 | 0
30 | 21 | 16 | sentennial | [PHONE] | -44.92328922 | 0 | 0 | 16 | 22 | 44.8 |  | 8 | 11
31 | 21 | 52 | sentennial | [PHONE] | -44.92256013 | 7 | 4 | 53 | 70 | 148.4 |  | 4 | 6
32 | 21 | 54 | sentennial | [PHONE] | -44.92251963 | 8 | 1 | 27 | 15 | 75.6 |  | 8 | 8
33 | 22 | 36 | sentennial | [PHONE] | -44.92289732 | 0 | 0 | 13 | 21 | 36.4 |  | 8 | 4
34 | 22 | 57 | sentennial | [PHONE] | -44.92247151 | 11 | 0 | 15 | 13 | 42 |  | 0 | 0
35 | 23 | 74 | sentennial | [PHONE] | -44.9221378 | 3 | 0 | 16 | 10 | 44.8 |  | 2 | 5
36 | 24 | 9 | sentennial | 169.286085 | -44.92346779 | 4 | 1 | 12 | 20 | 33.6 |  | 5 | 0
37 | 25 | 33 | sentennial | [PHONE] | -44.92299254 | 7 | 11 | 43 | 77 | 120.4 |  | 30 | 28
38 | 26 | 1 | sentennial | 169.285968 | -44.923653 | 6 | 3 | 85 | 80 | 238 |  | 6 | 6
39 | 26 | 19 | sentennial | [PHONE] | -44.92328802 | 0 | 4 | 6 | 21 | 16.8 |  | 0 | 0
40 | 27 | 72 | Lapin | [PHONE] | -44.92222722 | 116 | 112 | 19 |  | 53.2 |  | 40 | 74
41 | 28 | 65 | Lapin | [PHONE] | -44.92238007 | 40 | 61 | 47 |  | 131.6 |  | 136 | 111
42 | 29 | 4 | Lapin | [PHONE] | -44.92362817 | 36 | 28 | 57 |  | 159.6 |  | 214 | 196
43 | 30 | 16 | Lapin | [PHONE] | -44.92339549 | 60 | 87 | 18 |  | 50.4 |  | 86 | 59
44 | 30 | 17 | Lapin | [PHONE] | -44.92337518 | 17 | 11 | 11 |  | 30.8 |  | 55 | 28
45 | 32 | 72 | Lapin | [PHONE] | -44.92228362 | 25 | 8 | 22 |  | 61.6 |  | 25 | 18
46 | 35 | 7 | Lapin | 169.286298 | -44.92363927 | 24 | 18 | 34 |  | 95.2 |  | 89 | 35
47 | 35 | 67 | Lapin | [PHONE] | -44.92242193 | 21 | 32 | 35 |  | 98 |  | 135 | 112
48 | 36 | 12 | Lapin | [PHONE] | -44.92354882 | 34 | 43 | 45 | 45 | 126 |  | 77 | 34
49 | 36 | 34 | Lapin | [PHONE] | -44.92310247 | 160 | 215 | 25 |  | 70 |  | 398 | 417
50 | 37 | 69 | Lapin | [PHONE] | -44.92240535 | 11 | 4 | 52 |  | 145.6 |  | 5 | 5
51 | 39 | 76 | Sweetheart | [PHONE] | -44.92228716 | 6 | 1 | 28 |  | 78.4 |  | 4 | 3
52 | 40 | 5 | Sweetheart | [PHONE] | -44.92373599 | 17 | 13 | 34 |  | 95.2 |  | 45 | 33
53 | 40 | 6 | Sweetheart | [PHONE] | -44.92371574 | 33 | 6 | 78 |  | 218.4 |  | 57 | 32
54 | 40 | 12 | Sweetheart | [PHONE] | -44.92359423 | 13 | 5 | 22 |  | 61.6 |  | 18 | 7
55 | 40 | 75 | Sweetheart | [PHONE] | -44.92231833 | 26 | 1 | 29 |  | 81.2 |  | 7 | 3
56 | 41 | 45 | Sweetheart | [PHONE] | -44.92293836 | 16 | 4 | 112 |  | 313.6 |  | 128 | 66
57 | 42 | 20 | Sweetheart | [PHONE] | -44.92345774 | 33 | 2 | 33 |  | 92.4 |  | 21 | 12
58 | 42 | 44 | Sweetheart | [PHONE] | -44.9229711 | 25 | 0 | 16 |  | 44.8 |  | 13 | 10
59 | 42 | 48 | Sweetheart | [PHONE] | -44.92289 | 35 | 5 | 43 |  | 120.4 |  | 39 | 26
60 | 43 | 3 | Sweetheart | 169.286402 | -44.9238144 | 50 | 7 | 59 |  | 165.2 |  | 45 | 34
61 | 43 | 40 | Sweetheart | [PHONE] | -44.92306326 | 52 | 0 | 17 |  | 47.6 |  | 10 | 12
62 | 43 | 84 | Sweetheart |  |  | 38 | 13 | 45 |  | 126 |  | 27 | 14
63 | 44 | 37 | Sentennial | [PHONE] | -44.92313216 | 54 | 7 | 11 |  | 30.8 |  | 0 | 0
64 | 45 | 6 | Sentennial | [PHONE] | -44.92377756 | 101 | 11 | 66 |  | 184.8 |  | 16 | 11
65 | 45 | 72 | Sentennial | 169.287862 | -44.92243849 | 75 | 4 | 77 |  | 215.6 |  | 10 | 5
66 | 46 | 36 | Sentennial | [PHONE] | -44.92317989 | 48 | 3 | 8 |  | 22.4 |  | 2 | 2
67 | 46 | 42 | Sentennial | [PHONE] | -44.92305816 | 57 | 13 | 40 |  | 112 |  | 5 | 5
68 | 47 | 27 | Sentennial | [PHONE] | -44.92337549 | 102 | 49 | 85 |  | 238 |  | 30 | 19
69 | 47 | 28 | Sentennial | 169.287006 | -44.9233552 | 41 | 2 | 18 |  | 50.4 |  | 7 | 3
70 | 47 | 58 | Sentennial | [PHONE] | -44.92274653 | 64 | 1 | 62 |  | 173.6 |  | 25 | 18
71 | 48 | 62 | Sentennial | [PHONE] | -44.92267712 | 39 | 7 | 97 |  | 271.6 |  | 17 | 13
72 | 49 | 35 | Sentennial | [PHONE] | -44.92323442 | 85 | 18 | 47 |  | 131.6 |  | 25 | 16
73 | 50 | 23 | Sentennial | [PHONE] | -44.92349091 | 74 | 3 | 41 |  | 114.8 |  | 20 | 18
74 | 50 | 71 | Sentennial | [PHONE] | -44.92251763 | 121 | 15 | 183 |  | 512.4 |  | 37 | 21
75 | 52 | 30 | Sentennial | [PHONE] | -44.92337198 | 110 | 13 | 162 |  | 453.6 |  | 84 | 62
76 | 52 | 58 | Sentennial | [PHONE] | -44.92280423 | 85 | 43 | 31 |  | 86.8 |  | 67 | 28
77 | 53 | 14 | Lapins | [PHONE] | -44.9237094 | 100 | 100 | 58 |  | 162.4 |  | 90 | 135
78 | 53 | 15 | Lapins | [PHONE] | -44.92368913 | 53 | 140 | 56 |  | 156.8 |  | 109 | 114
79 | 53 | 56 | Lapins | [PHONE] | -44.92285778 | 48 | 84 | 147 |  | 411.6 |  | 350 | 494
80 | 54 | 51 | Lapins | [PHONE] | -44.92297017 | 21 | 100 | 210 |  | 588 |  | 425 | 289
 | 54 | 76 | Lapins | [PHONE] | -44.92246325 | 50 | 65 | 120 |  | 336 |  | 325 | 318
 | 55 | 41 | Lapins | [PHONE] | -44.92318337 | 17 | 24 | 19 |  | 53.2 |  | 60 | 85
 | 55 | 73 | Lapins | 169.288113 | -44.92253646 | 61 | 86 | 245 |  | 686 |  | 290 | 803
 | 56 | 49 | Lapins | 169.287645 | -44.92303548 | 46 | 325 | 84 |  | 235.2 |  | 130 | 203
 | 58 | 1 | Lapins | 169.286709 | -44.924031 | 111 | 157 | 38 | 43 | 106.4 | 57 | 75 | 113
 | 58 | 40 | Lapins | [PHONE] | -44.92324116 | 26 | 35 | 84 |  | 235.2 |  | 170 | 229
 | 58 | 69 | Lapins | [PHONE] | -44.92265384 | 28 | 36 | 86 |  | 240.8 |  | 120 | 194
 | 59 | 81 | Lapins | [PHONE] | -44.92242186 | 26 | 50 | 92 |  | 257.6 |  | 230 | 243
 | 59 | 82 | Lapins | [PHONE] | -44.92240158 | 50 | 73 | 160 |  | 448 |  | 140 | 391
90 | 60 | 85 | Lapins |  |  | 30 | 55 | 56 |  | 156.8 | 73 | 100 | 184
 | 62 | 55 | Lapins | [PHONE] | -44.92298269 | 24 | 6 | 24 |  | 67.2 | 22 | 30 | 39
 | 64 | 33 | Sentennial | [PHONE] | -44.92345337 | 19 | 20 | 62 |  | 173.6 | 84 | 33 | 28
 | 64 | 56 | Sentennial | [PHONE] | -44.92298644 | 29 | 3 | 165 |  | 462 | 203 | 88 | 55
 | 65 | 9 | Sentennial | [PHONE] | -44.92395088 | 35 | 30 | 51 |  | 142.8 |  | 11 | 23
 | 65 | 53 | Sentennial | [PHONE] | -44.92305925 | 17 | 14 | 212 |  | 593.6 | 208 | 272 | 205
96 | 66 | 83 | Sentennial | [PHONE] | -44.92246231 | 22 | 6 | 210 |  | 588 | 361 | 222 | 216
 | 67 | 47 | Sentennial | [PHONE] | -44.92320615 | 16 | 2 | 140 |  | 392 |  | 101 | 75
 | 68 | 42 | Sentennial | [PHONE] | -44.92331816 | 49 | 14 | 58 | 64 | 162.4 | 51 | 25 | 22
100 | 69 | 3 | Sentennial | [PHONE] | -44.92412047 | 60 | 19 | 90 |  | 252 | 62 | 17 | 16
 | 71 | 42 | Kootenay | [PHONE] | -44.92335266 |  | 1 |  |  | 0 | 74 | 25 | 22
 | 72 | 35 | [NAME] | [PHONE] | -44.92350384 |  |  |  |  | 0 |  | 14 | 8
 | 72 | 60 | [NAME] | [PHONE] | -44.92299783 |  |  |  |  | 0 |  | 12 | 16
 | 74 | 45 | Kootenay | [PHONE] | -44.92332644 |  | 33 | 21 |  | 58.8 |  | 40 | 34
 | 75 | 61 | [NAME] | [PHONE] | -44.9230134 |  |  |  |  | 0 |  | 9 | 6
 | 76 | 7 | [NAME] | [PHONE] | -44.92411934 |  |  |  |  | 0 |  | 12 | 8
 | 76 | 45 | [NAME] | [PHONE] | -44.92334882 |  |  |  |  | 0 |  | 11 | 2
108 | 78 | 62 | Kootenay | [PHONE] | -44.92302686 |  | 15 | 38 |  | 106.4 | 50 | 23 | 27
109 | 78 | 83 | Kootenay | [PHONE] | -44.92260131 |  | 5 | 42 |  | 117.6 | 38 | 40 | 72
 | 80 | 20 | [NAME] | 169.28761 | -44.92390244 |  |  |  |  | 0 |  | 14 | 8
 | 81 | 83 | Kootenay | [PHONE] | -44.9226363 |  | 1 | 48 | 70 | 134.4 |  | 125 | 125
 | 82 | 73 | Kootenay | [PHONE] | -44.92285383 |  | 0 | 30 | 17 | 84 |  | 33 | 33
 | 83 | 76 | [NAME] | [PHONE] | -44.92280307 |  |  |  |  | 0 |  | 10 | 5
 | 84 | 41 | [NAME] | [PHONE] | -44.92352291 |  |  |  |  | 0 |  | 0 | 0
 | 85 | 10 | Kootenay | [PHONE] | -44.92416295 |  | 15 | 17 |  | 47.6 |  | 58 | 39
 | 85 | 45 | Kootenay | [PHONE] | -44.92345497 |  | 11 | 36 |  | 100.8 |  | 88 | 75
 | 86 | 55 | Kootenay | [PHONE] | -44.92326335 |  | 10 | 26 |  | 72.8 |  | 34 | 31
 | 87 | 37 | [NAME] | 169.288121 | -44.92364048 |  |  |  |  | 0 |  | 6 | 5
 | 87 | 74 | [NAME] | [PHONE] | -44.92289069 |  |  |  |  | 0 |  | 11 | 11
 | 88 | 38 | [NAME] | [PHONE] | -44.92363266 |  |  |  |  | 0 |  | 21 | 17
 | 88 | 48 | [NAME] | [PHONE] | -44.92343014 |  |  |  |  | 0 |  | 27 | 15
 | 89 | 25 | Kootenay | [PHONE] | -44.92390694 |  | 57 | 14 |  | 39.2 |  | 62 | 54
 | 89 | 34 | Kootenay | [PHONE] | -44.92372467 |  | 25 | 25 | 28 | 70 |  | 64 | 56
 | 89 | 45 | Kootenay | [PHONE] | -44.9235019 |  | 4 | 16 | 19 | 44.8 |  | 22 | 19
125 | 89 | 76 | Kootenay | [PHONE] | -44.92287407 |  | 11 | 21 | 35 | 58.8 | 39 | 65 | 63
126 | 90 | 33 | Kootenay | [PHONE] | -44.92375554 |  | 14 | 26 | 50 | 72.8 | 50 | 112 | 79
 | 91 | 24 | [NAME] | [PHONE] | -44.92395092 |  |  |  |  | 0 |  | 7 | 3
 | 91 | 49 | [NAME] | [PHONE] | -44.9234443 |  |  |  |  | 0 |  | 5 | 4
 | 92 | 23 | [NAME] | [PHONE] | -44.92398318 |  |  |  |  | 0 |  | 4 | 5
 | 92 | 24 | [NAME] | [PHONE] | -44.92396292 |  |  |  |  | 0 |  | 4 | 2
 | 93 | 17 | Kootenay | [PHONE] | -44.92411596 |  | 0 | 29 | 29 | 81.2 |  | 44 | 37
 | 93 | 51 | Kootenay | [PHONE] | -44.92342738 |  | 10 | 26 | 26 | 72.8 |  | 56 | 61
 | 93 | 61 | Kootenay | 169.288751 | -44.92322486 |  | 20 | 33 | 30 | 92.4 |  | 63 | 60
 | 94 | 16 | Kootenay | [PHONE] | -44.92414903 |  | 36 | 52 | 50 | 145.6 |  | 149 | 98
 | 94 | 63 | Kootenay | 169.288815 | -44.9231966 |  | 5 | 11 | 26 | 30.8 |  | 16 | 18
 | 95 | 24 | [NAME] | [PHONE] | -44.92399804 |  |  |  |  | 0 |  | 28 | 17
 | 95 | 74 | [NAME] | [PHONE] | -44.92298725 |  |  |  |  | 0 |  | 6 | 5
 | 96 | 66 | [NAME] | [PHONE] | -44.9231586 |  |  |  |  | 0 |  | 11 | 12
 | 97 | 61 | Kootenay | 169.288845 | -44.92327213 |  | 11 | 12 |  | 33.6 |  | 48 | 44
 | 99 | 49 | [NAME] | [PHONE] | -44.92353947 |  |  |  |  | 0 |  | 8 | 3
 | 100 | 6 | [NAME] | [PHONE] | -44.92442086 |  |  |  |  | 0 |  | 4 | 5
 | 100 | 12 | [NAME] | [PHONE] | -44.92429949 |  |  |  |  | 0 |  | 9 | 3
 | 100 | 39 | [NAME] | [PHONE] | -44.92375334 |  |  |  |  | 0 |  | 10 | 4
 | 101 | 9 | Kootenay | 169.287873 | -44.92437298 |  | 6 | 13 |  | 36.4 |  | 35 | 27
 | 102 | 13 | Kootenay | [PHONE] | -44.92430412 |  | 1 | 13 |  | 36.4 |  | 27 | 15
 | 103 | 69 | [NAME] | [PHONE] | -44.92317918 |  |  |  |  | 0 |  | 0 | 0
 | 104 | 57 | [NAME] | [PHONE] | -44.92343455 |  |  |  |  | 0 |  | 1 | 0
 | 105 | 46 | Kootenay | [PHONE] | -44.92367165 |  | 22 | 29 |  | 81.2 |  | 55 | 56
 | 106 | 17 | Kootenay | 169.288155 | -44.92426835 |  | 0 | 9 |  | 25.2 |  | 12 | 10
 | 106 | 25 | Kootenay | [PHONE] | -44.92410653 |  | 21 | 24 |  | 67.2 |  | 58 | 33
 | 107 | 20 | [NAME] | [PHONE] | -44.92421744 |  |  | 68 |  | 190.4 |  | 25 | 14
 | 109 | 29 | Kootenay | [PHONE] | -44.92395521 |  | 9 | 27 |  | 75.6 |  | 65 | 65
 | 109 | 43 | Kootenay |  |  |  | 2 | 23 |  | 64.4 |  | 23 | 23
 | 110 | 14 | Kootenay | [PHONE] | -44.92435347 |  | 14 | 23 |  | 64.4 |  | 48 | 88
 | 110 | 23 | Kootenay | [PHONE] | -44.9241724 |  | 4 | 22 |  | 61.6 |  | 50 | 44
 | 111 | 3 | Kootenay | [PHONE] | -44.92434146 |  | 1 | 32 |  | 89.6 |  | 82 | 25
 |  |  |  |  |  |  |  |  |  |  |  |  |  | -43.25%
 |  |  |  |  |  |  |  |  |  | 2.8
 |  |  |  |  |  | 43.1025641 | 69.84210526 | 71.51282051 | 88.73333333 | Lapin | 60 | 146 | 191.6153846 | 13.91%
 |  |  |  |  |  | 30.83333333 | 14.66666667 | 70.93333333 | 84.90909091 | Sweetheart | 144.1428571 | 61.5 | 57.17241379 | -77.08%
 |  |  |  |  |  | 37.66666667 | 7.233333333 | 46.37931034 | 33.875 | Sentennial | 67 | 14.46666667 | 10.33333333 | -91.87%
 |  |  |  |  |  | #[NAME]! | 12.13333333 | 25.44827586 | 34.54545455 |  | 50.2 | 54.06666667 | 47.76666667
 |  |  |  |  |  | #[NAME]! | #[NAME]! | 68 | #[NAME]! | 7.323076923 | #[NAME]! | 10.34615385 | 6.846153846