Spreadsheet: 87186d1287047114-find-string-and-get-column-data-cityfindmacro
Sheet: SUBURB

 | Perth
 | 223.5893859863281
 | 236.8446807861328 |  |  |  | Type an properly spelled string into row1
 | 205.5821838378906 |  |  |  | and the column will fill in if matched
 | 216.5865936279297
 | 239.5957946777344 |  |  |  | Delete a value in row1 to clear that column
 | 239.3456878662109
 | 239.8458862304688
 | 255.6021881103516
 | 245.5981903076172
 | 229.8418884277344
 | 268.8574829101562
 | 152.5609893798828
 | 133.3032989501953
 | 144.3076934814453
 | 283.1131896972656
 | 283.6133728027344
 | 188.5753936767578
 | 180.3220977783203
 | 156.8126983642578
 | 142.8070983886719
 | 138.0551910400391
 | 151.8106994628906
 | 165.3160858154297
 | 164.0655975341797
 | 210.3340911865234
 | 183.823486328125
 | 217.5869903564453
 | 198.0791931152344
 | 138.0551910400391
 | 181.3224945068359
 | 298.619384765625
 | 284.8638916015625
 | 298.3692932128906
 | 241.0963897705078
 | 182.0727844238281
 | 161.5645904541016
 | 127.300895690918
 | 127.0507965087891
 | 184.5737915039062
 | 242.3468933105469
 | 277.3608703613281
 | 317.1267700195312
 | 263.1051940917969
 | 183.823486328125
 | 150.8102874755859
 | 198.3292846679688
 | 153.3112945556641
 | 156.5625915527344
 | 164.0655975341797
 | 199.5797882080078
 | 272.8591003417969
 | 300.8702697753906
 | 181.0723876953125
 | 242.0967864990234
 | 141.8066864013672
 | 126.0503921508789
 | 126.0503921508789
 | 137.8050994873047
 | 226.0903930664062
 | 217.8370819091797
 | 121.5485916137695
 | 128.5513916015625
 | 146.8086853027344
 | 183.823486328125
 | 193.577392578125
 | 191.0763854980469
 | 197.5789947509766
 | 223.5893859863281
 | 247.5989837646484
 | 158.8134918212891
 | 140.5561981201172
 | 134.3036956787109
 | 153.0611877441406
 | 176.0703887939453
 | 153.5613861083984
 | 105.0419921875
 | 105.2920913696289
 | 102.5409927368164
 | 100.5401916503906
 | 94.53779602050781
 | 97.78909301757812
 | 105.0419921875
 | 101.040397644043
 | 102.5409927368164
 | 120.7982940673828
 | 144.0575866699219
 | 106.542594909668
 | 107.2928924560547
 | 110.7942962646484
 | 107.7930908203125
 | 105.7922973632812
 | 113.7954940795898
 | 116.0463943481445
 | 109.2936935424805
 | 109.0435943603516
 | 116.5465927124023
 | 125.5501937866211
 | 126.5505905151367
 | 134.8038940429688
 | 123.0491943359375
 | 120.298095703125
 | 123.2992935180664
 | 103.5413970947266
 | 112.7950973510742
 | 109.2936935424805
 | 111.7946929931641
 | 114.2956924438477
 | 110.2940979003906
 | 113.295295715332
 | 114.2956924438477
 | 114.5457916259766
 | 110.0439910888672
 | 111.2944946289062
 | 110.5441970825195
 | 102.5409927368164
 | 98.53939819335938
 | 110.7942962646484
 | 113.295295715332
 | 112.2948913574219
 | 112.5449905395508
 | 108.2932968139648
 | 110.2940979003906
 | 108.7934951782227
 | 114.2956924438477
 | 111.7946929931641
 | 113.0451965332031
 | 114.0455932617188
 | 108.0431976318359
 | 108.5433959960938
 | 107.0427932739258
 | 115.0459976196289
 | 115.7962951660156
 | 115.0459976196289
 | 115.7962951660156
 | 109.0435943603516
 | 109.5437927246094
 | 105.0419921875
 | 116.2964935302734
 | 116.0463943481445
 | 116.5465927124023
 | 124.0495910644531
 | 135.55419921875
 | 127.300895690918
 | 124.0495910644531
 | 138.5553894042969
 | 124.5497970581055
 | 121.0483932495117
 | 118.2972946166992
 | 232.5929870605469
 | 109.5437927246094
 | 104.0415954589844
 | 108.5433959960938
 | 115.2960968017578
 | 125.0499954223633
 | 133.0531921386719
 | 123.5493927001953
 | 127.8010940551758
 | 133.0531921386719
 | 135.0539855957031
 | 128.3013000488281
 | 122.7990951538086
 | 143.8074951171875
 | 142.0567932128906
 | 142.3069000244141
 | 135.3040924072266
 | 132.0527954101562
 | 135.8042907714844
 | 134.8038940429688
 | 135.0539855957031
 | 142.5569915771484
 | 141.056396484375
 | 140.3060913085938
 | 148.5593872070312
 | 160.3140869140625
 | 158.3132934570312
 | 136.3044891357422
 | 144.0575866699219
 | 136.0543975830078
 | 127.8010940551758
 | 158.5633850097656
 | 158.8134918212891
 | 142.5569915771484
 | 148.3092956542969
 | 148.8094940185547
 | 147.5589904785156
 | 130.8022918701172
 | 138.3052978515625
 | 149.3096923828125
 | 150.0599975585938
 | 133.8034973144531
 | 143.0571899414062
 | 137.5549926757812
 | 139.8058929443359
 | 146.0583953857422
 | 151.5605926513672
 | 135.0539855957031
 | 145.5581970214844
 | 133.8034973144531
 | 127.8010940551758
 | 141.056396484375
 | 250.8502807617188
 | 149.8098907470703
 | 149.0595855712891
 | 145.3080902099609
 | 144.3076934814453
 | 148.8094940185547
 | 153.8114929199219
 | 152.8110961914062
 | 151.5605926513672
 | 147.0587921142578
 | 142.8070983886719
 | 133.3032989501953
 | 133.8034973144531
 | 134.3036956787109
 | 135.0539855957031
 | 130.0519866943359
 | 115.2960968017578
 | 125.0499954223633
 | 121.2984924316406
 | 120.298095703125
 | 115.5461959838867
 | 127.0507965087891
 | 127.300895690918
 | 125.0499954223633
 | 127.8010940551758
 | 128.3013000488281
 | 202.8310852050781
 | 133.5533905029297
 | 132.5529937744141
 | 131.302490234375
 | 127.5509948730469
 | 134.5537872314453
 | 128.0511932373047
 | 125.0499954223633
 | 135.3040924072266
 | 125.3000946044922
 | 121.5485916137695
 | 124.0495910644531
 | 127.0507965087891
 | 136.5545959472656
 | 130.8022918701172
 | 128.0511932373047
 | 127.300895690918
 | 132.3028869628906
 | 139.0555877685547
 | 134.5537872314453
 | 120.298095703125
 | 130.3020935058594
 | 117.7970962524414
 | 132.8031005859375
 | 122.5489959716797
 | 116.0463943481445
 | 133.0531921386719
 | 125.3000946044922
 | 127.8010940551758
 | 119.2976913452148
 | 120.7982940673828
 | 129.0515899658203
 | 119.0475921630859
 | 124.7998962402344
 | 115.2960968017578
 | 117.2968902587891
 | 120.298095703125
 | 142.0567932128906
 | 123.7994918823242
 | 115.0459976196289
 | 122.7990951538086
 | 113.295295715332
 | 105.2920913696289
 | 96.7886962890625
 | 116.0463943481445
 | 136.5545959472656
 | 127.5509948730469
 | 113.7954940795898
 | 107.0427932739258
 | 105.7922973632812
 | 111.7946929931641
 | 109.5437927246094
 | 103.5413970947266
 | 104.7918930053711
 | 107.2928924560547
 | 100.2900924682617
 | 102.7910919189453
 | 110.5441970825195
 | 111.7946929931641
 | 108.5433959960938
 | 107.0427932739258
 | 163.3152923583984
 | 108.2932968139648
 | 131.5525970458984
 | 103.7914962768555
 | 104.5417938232422
 | 102.0407943725586
 | 100.7902984619141
 | 101.7906951904297
 | 107.2928924560547
 | 100.5401916503906
 | 108.0431976318359
 | 104.7918930053711
 | 114.2956924438477
 | 103.0411911010742
 | 86.78469848632812
 | 99.2896957397461
 | 98.03919219970703
 | 100.0399932861328
 | 103.0411911010742
 | 109.7938919067383
 | 125.5501937866211
 | 119.5477905273438
 | 105.0419921875
 | 97.0387954711914
 | 95.03799438476562
 | 105.2920913696289
 | 108.5433959960938
 | 123.0491943359375
 | 125.3000946044922
 | 104.0415954589844
 | 96.03839111328125
 | 100.7902984619141
 | 102.0407943725586
 | 98.53939819335938
 | 101.5405960083008
 | 101.5405960083008
 | 95.28809356689453
 | 95.03799438476562
 | 102.5409927368164
 | 117.0467910766602
 | 130.3020935058594
 | 96.28849792480469
 | 98.03919219970703
 | 94.03759765625
 | 106.2924957275391
 | 98.53939819335938
 | 100.0399932861328
 | 99.539794921875
 | 95.28809356689453
 | 104.0415954589844
 | 134.8038940429688
 | 161.0643920898438
 | 113.0451965332031
 | 114.2956924438477
 | 98.78949737548828
 | 104.2916946411133
 | 105.2920913696289
 | 117.5469970703125
 | 163.3152923583984
 | 170.5681915283203
 | 127.5509948730469
 | 102.7910919189453
 | 101.040397644043
 | 109.7938919067383
 | 146.8086853027344
 | 190.8262939453125
 | 178.8214874267578
 | 158.8134918212891
 | 126.5505905151367
 | 108.5433959960938
 | 114.7958908081055
 | 124.5497970581055
 | 133.3032989501953
 | 132.0527954101562
 | 178.0711975097656
 | 170.8182983398438
 | 127.0507965087891
 | 100.2900924682617
 | 96.5385971069336
 | 156.8126983642578
 | 178.0711975097656
 | 197.3288879394531
 | 204.581787109375
 | 163.065185546875
 | 120.7982940673828
 | 142.8070983886719
 | 145.5581970214844
 | 97.0387954711914
 | 101.7906951904297
 | 113.7954940795898
 | 161.814697265625
 | 180.8222961425781
 | 165.5661926269531
 | 180.5721893310547
 | 233.8434906005859
 | 338.8854675292969
 | 236.0943908691406
 | 176.8206939697266
 | 146.0583953857422
 | 156.3124847412109
 | 224.0895843505859
 | 194.8278961181641
 | 203.8314819335938
 | 217.8370819091797
 | 260.1039733886719
 | 256.6026000976562
 | 251.1003875732422
 | 175.8202972412109
 | 148.0591888427734