Postcode to postcode distance

[thesilkster]

Hi Guys


i have a spreadsheet that has in column A postcode start and in column B postcode finish is there any way i could get the distance traveled? in column C


regards


any help appreciated


Carl

 

[thesilkster]

i have a distance chart like this that has distances from post code to post code from paragon

`


.....AB1 AL1 B1 BA1 BB1 BD1 BH1 BL1

AB1 0 516 426 518 326 339 568 339

AL1 516 0 97 119 206 181 115 191

B1 426 97 0 99 115 131 161 101

BA1 518 119 99 0 207 223 68 193

BB1 326 206 115 207 0 40 257 14

BD1 339 181 131 223 40 0 290 45

BH1 568 115 161 68 257 290 0 243

BL1 339 191 101 193 14 45 243 0

BN1 597 89 169 150 286 264 95 272

BR1 550 35 131 121 239 214 117 224

BS1 507 125 88 14 197 212 77 182

CA1 232 285 194 286 95 107 336 107

CB1 526 46 107 175 215 165 171 200

CF1 533 158 114 56 222 238 125 208

 

[NARAYANK991]

Hi ,


I googled this using :


excel code distance


and the result is promising :


https://www.google.co.in/#hl=en&sclient=psy-ab&q=excel+code+distance&oq=excel+code+distance&gs_l=hp.3..0i22i30l4.921.12468.0.12968.19.19.0.0.0.0.812.5060.0j5j11j2j6-1.19.0.crnk_timepromotionb..0.0...1.1.8.psy-ab.bEKKKcEYnks&pbx=1&bav=on.2,or.r_qf.&bvm=bv.44770516,d.bmk&fp=9f26de717d992561&biw=1366&bih=616


or in its shortened form ( through bitly.com ) :


http://bit.ly/11zWVaW


Narayan

 

[Kevin@Radstock]

Hi thesilkster


Try:

http://www.excelforum.com/excel-tips/845249-uk-postcode-distance-calculator.html

 

[shrivallabha]

If your distance chart posted above is in range, A1:I15 then you can use,


=INDEX(B2:I15,MATCH(L2,A2:A15,0),MATCH(K2,B1:I1,0))


where L2, K2 hold a valid combination available in the chart.

 

[thesilkster]

thanks guys i managed to use this

=INDEX(data,MATCH(B7,INDEX(data,,1),0),MATCH(A7,INDEX(data,1,),0))


thanks Shrivallabha i will also persue the links as my distance chart is limited


thanks


thesilkster