Matrix and kilometers

Dear reader,

The Matrix below shows the distances between different cities in Poland. I have a dataset with courier services where the recipient city and sender city of the package are shown. I would like to create a formula that calculates the distance for me.

I have only come so far:

=IF(AND(A2=”WARSAW”,B2=”OLSTYN”);380;?

Then repeat over and over with differenent combinations… (very inefficient)

Is there anyway you could help? Thanks in advance! 

<!–td {border: 1px solid #ccc;}br {mso-data-placement:same-cell;}–>

City Warsaw Olsztyn Lublin Krakow Katowice Wroclaw Poznan Szczecin Gdansk Lodz
Warsaw 150 380 320 440 410 510 480 760 580 270
Olsztyn 380 180 550 700 610 670 530 680 340 450
Lublin 320 550 150 470 520 630 640 920 730 430
Krakow 440 700 470 140 200 420 650 830 740 400
Katowice 410 610 520 200 100 320 560 730 650 310
Wroclaw 510 670 630 420 320 160 350 560 710 360
Poznan 480 530 640 650 560 350 200 480 490 380
Szczecin 760 680 920 830 730 560 480 220 550 650
Gdansk 580 340 730 740 650 710 490 550 170 480
Lodz 270 450 430 400 310 360 380 650 480 130

 

 

By: Lucas

42 thoughts on “Matrix and kilometers

  1. Buy Methenolone enanthate

    Hey there! This is my first visit to your blog! We are a group of volunteers and starting a new initiative in a community in the same niche. Your blog provided us valuable information to work on. You have done a wonderful job!

  2. zodiac casino 80 free spins betrouwbaar

    casino geen storting bonus , drueck glueck spins zonder storting – gratis gokken club 2000 : geld overmaken ing zonder mobiel .

  3. holland casino eindhoven kerst

    gokkasten strategie , betrouwbare online casino – casino spellen online gratis : tijdelijke vestiging holland casino groningen .

  4. casino 5 euro storten

    casino met gratis welkomstbonus , spelletjes casino online – groot bedrag gewonnen holland casino : gratis fruitmachines spelletjes .

  5. HCG kaufen

    At this time it appears like Expression Engine is the best blogging platform available right now. (from what I’ve read) Is that what you are using on your blog?

  6. coach factory outlet

    I have to show my appreciation to you for bailing me out of such a dilemma. After surfing throughout the the web and meeting principles which were not helpful, I assumed my entire life was over. Being alive minus the answers to the difficulties you have solved through your main report is a crucial case, and those which might have negatively damaged my entire career if I hadn’t come across your website. Your primary training and kindness in touching every item was vital. I am not sure what I would have done if I had not discovered such a point like this. I am able to at this moment look forward to my future. Thanks very much for your expert and amazing help. I won’t think twice to suggest your blog to any individual who wants and needs support on this issue.

  7. check out your url

    I wanted to send you that very little observation so as to thank you so much over again with your marvelous pointers you have documented on this page. This is incredibly open-handed with you to give unreservedly precisely what a few people might have marketed as an electronic book to help make some cash for themselves, particularly given that you might well have tried it if you ever decided. These pointers additionally served as the easy way to be certain that other people have the same dreams really like my very own to realize a lot more on the subject of this matter. I’m sure there are a lot more enjoyable moments up front for people who browse through your site.

  8. hermes handbags

    I want to show thanks to this writer just for rescuing me from this type of trouble. After surfing throughout the search engines and coming across strategies which are not productive, I was thinking my entire life was gone. Living without the answers to the problems you’ve sorted out by means of your good guide is a critical case, as well as those that would have badly damaged my career if I hadn’t discovered your web page. That capability and kindness in handling all the stuff was invaluable. I’m not sure what I would’ve done if I hadn’t discovered such a stuff like this. I am able to at this moment relish my future. Thanks a lot so much for this high quality and results-oriented help. I will not think twice to suggest your web sites to any person who needs to have care on this problem.

  9. ig

    I have been surfing online more than 2 hours
    today, yet I never found any interesting article like
    yours. It’s pretty worth enough for me. Personally,
    if all web owners and bloggers made good content as you did, the web
    will be much more useful than ever before.

  10. Georgianna

    Excellent post however , I was wanting to
    know if you could write a litte more on this topic?
    I’d be very grateful if you could elaborate a little bit more.
    Cheers!

  11. off white

    I intended to write you the tiny word so as to say thank you yet again on your gorgeous solutions you’ve shared on this page. This has been so shockingly open-handed with you to supply publicly what exactly many of us might have offered as an e book to help make some cash for their own end, mostly considering that you could have tried it if you decided. Those tricks additionally worked like a good way to fully grasp most people have similar passion like mine to realize lots more when considering this condition. I am certain there are millions of more fun occasions ahead for individuals that read your website.

  12. cheap jordans

    I wanted to write you a bit of note so as to give many thanks the moment again on your spectacular knowledge you’ve featured here. This has been certainly unbelievably open-handed with you to offer easily all that most of us might have offered as an ebook to help make some cash on their own, certainly given that you could possibly have tried it in case you wanted. Those basics also acted to become great way to comprehend other individuals have the identical dreams like my personal own to realize somewhat more on the subject of this issue. Certainly there are several more fun situations ahead for many who scan through your site.

  13. air jordan shoes

    I just wanted to write a quick message in order to say thanks to you for all the marvelous advice you are writing on this website. My time consuming internet research has now been recognized with brilliant suggestions to write about with my classmates and friends. I would assume that we website visitors are unequivocally blessed to live in a fabulous network with many brilliant individuals with valuable hints. I feel pretty fortunate to have encountered the webpages and look forward to really more entertaining moments reading here. Thanks a lot again for everything.

  14. Andres Bowlds

    Have you ever considered about including a little bit more than just your articles? I mean, what you say is fundamental and everything. Nevertheless think about if you added some great images or video clips to give your posts more, “pop”! Your content is excellent but with pics and video clips, this site could definitely be one of the best in its niche. Fantastic blog!

  15. Buy Fioricet

    Hey very cool web site!! Man .. Beautiful .. Amazing .. I will bookmark your web site and take the feeds also…I am happy to find a lot of useful information here in the post, we need work out more techniques in this regard, thanks for sharing. . . . . .

  16. Buy Handicraft Items

    Have you ever considered about including a little bit more than just your articles? I mean, what you say is important and all. Nevertheless think about if you added some great images or video clips to give your posts more, “pop”! Your content is excellent but with images and videos, this blog could undeniably be one of the very best in its niche. Awesome blog!

  17. nike basketball shoes

    I truly wanted to post a brief remark in order to appreciate you for those fantastic techniques you are sharing on this site. My particularly long internet look up has at the end of the day been recognized with professional ideas to go over with my great friends. I would declare that many of us website visitors are very blessed to live in a remarkable website with very many outstanding people with useful basics. I feel rather fortunate to have seen your entire website and look forward to really more pleasurable times reading here. Thank you once again for everything.

  18. adidas yeezy boost

    I have to express my appreciation to this writer for bailing me out of this particular difficulty. As a result of scouting through the the web and meeting tricks that were not powerful, I figured my life was done. Existing minus the answers to the problems you have resolved through your main website is a serious case, and the ones that would have negatively damaged my entire career if I had not come across your web site. Your own knowledge and kindness in maneuvering every item was precious. I am not sure what I would have done if I hadn’t come upon such a step like this. I can at this point relish my future. Thanks a lot so much for your high quality and result oriented help. I won’t be reluctant to propose your web sites to anyone who would need counselling about this topic.

  19. Ted Poff

    I really appreciate this post. I have been looking all over for this! Thank goodness I found it on Bing. You have made my day! Thanks again!

  20. converse

    I want to express appreciation to you just for bailing me out of this particular crisis. Just after exploring throughout the the net and finding proposals which are not productive, I assumed my life was done. Being alive minus the solutions to the issues you’ve sorted out as a result of your main short article is a serious case, and ones which might have adversely affected my entire career if I had not come across your web page. Your good skills and kindness in controlling every item was useful. I don’t know what I would’ve done if I had not encountered such a point like this. It’s possible to now look forward to my future. Thank you very much for the skilled and effective help. I won’t be reluctant to refer your web blog to any person who will need tips about this topic.

  21. michael kors outlet store

    I must get across my respect for your kind-heartedness for those people that really need help with your matter. Your personal commitment to getting the solution around turned out to be pretty functional and have frequently encouraged men and women much like me to get to their targets. Your amazing valuable guidelines means this much to me and even further to my colleagues. Many thanks; from everyone of us.

  22. yeezy boost 350 v2

    A lot of thanks for all your work on this web site. My mother takes pleasure in making time for research and it’s really obvious why. Most of us know all regarding the compelling manner you deliver priceless tactics by means of the blog and as well as cause participation from some others on that area of interest while our favorite girl is without a doubt being taught so much. Take pleasure in the remaining portion of the year. You’re carrying out a great job.

  23. hogan outlet online

    I precisely needed to appreciate you once again. I’m not certain the things I would have done in the absence of those techniques provided by you directly on that topic. Certainly was a depressing circumstance in my position, but considering your specialized mode you solved that made me to jump for happiness. Extremely thankful for the advice and sincerely hope you really know what a great job you’re providing instructing the mediocre ones by way of a site. I’m certain you’ve never got to know any of us.

  24. golden goose

    I needed to compose you this bit of observation to finally give thanks as before for those stunning advice you’ve provided on this site. It is so shockingly open-handed with you to convey easily just what many people could have supplied for an ebook in order to make some dough for themselves, principally considering that you could have tried it in case you desired. The thoughts as well acted as the easy way to fully grasp that other individuals have the identical zeal like my personal own to figure out great deal more in regard to this matter. I am certain there are some more enjoyable instances up front for individuals who start reading your blog.

  25. supreme clothing

    Thanks so much for providing individuals with a very splendid possiblity to read articles and blog posts from here. It’s usually so pleasant and as well , stuffed with a good time for me personally and my office co-workers to search your blog at the least thrice every week to read the new things you will have. And indeed, I’m also actually motivated concerning the extraordinary knowledge you serve. Some 2 areas in this posting are particularly the most efficient we have all had.

  26. birkin bag

    I simply had to appreciate you once more. I am not sure what I would’ve handled without the entire points documented by you over that area. It was an absolute frightening scenario for me personally, but being able to see the very specialized tactic you solved the issue forced me to cry over gladness. I’m just happy for your work and in addition hope you know what a great job you are always providing educating the rest using a web site. Most probably you haven’t got to know all of us.

  27. hermes belt

    A lot of thanks for your entire hard work on this blog. Kim takes pleasure in setting aside time for investigations and it’s easy to understand why. Almost all hear all regarding the compelling ways you deliver both interesting and useful information via this blog and therefore foster participation from other people on that content plus our own princess is without question starting to learn a lot of things. Enjoy the remaining portion of the year. You have been performing a tremendous job.

  28. golden goose sneakers

    The next time I learn a blog, I hope that it doesnt disappoint me as a lot as this one. I mean, I know it was my choice to read, however I really thought youd have one thing fascinating to say. All I hear is a bunch of whining about something that you possibly can fix if you werent too busy in search of attention.

  29. adidas nmd r1

    This is the best blog for anybody who needs to search out out about this topic. You understand a lot its nearly laborious to argue with you (not that I actually would need匟aHa). You definitely put a new spin on a topic thats been written about for years. Nice stuff, simply great!

Comments are closed.