# Distance lookup table

**URL:** <https://community.glideapps.com/t/distance-lookup-table/67163>\
**Category:** Ask for Help\
**Created:** [October 21, 2023, 2:28am UTC](https://community.glideapps.com/t/distance-lookup-table/67163 "2023-10-21T02:28:56Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Dan\_San](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/dan_san/32/24085_2.png) [@Dan\_San](https://community.glideapps.com/u/Dan_San)\
**Post date:** [October 21, 2023, 2:28am UTC](https://community.glideapps.com/t/distance-lookup-table/67163/1 "2023-10-21T02:28:56Z")

</div>

I want to implement a lookup table to figure out distance between two towns. Any ideas how I can do this within glide and avoid going to to a an external call ?

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/4/e/4e598d1cbe5e758e38604bb9f6967df0e66ef44d.png)

---

<div class="post-metadata">

**Author:** ![Dan\_San](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/dan_san/32/24085_2.png) [@Dan\_San](https://community.glideapps.com/u/Dan_San)\
**Post date:** [October 21, 2023, 4:07pm UTC](https://community.glideapps.com/t/distance-lookup-table/67163/2 "2023-10-21T16:07:21Z")

</div>

I was unable to figure this out in Glide, but as I am using googlesheets I just used INDEX, MATCH

For anyone in the future  
=index(distance!1:1000,match(D2,distance!A:A,0),match(E2,distance!1:1,0))

---

<div class="post-metadata">

**Author:** ![system](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/system/32/53398_2.png) [@system](https://community.glideapps.com/u/system)\
**Post date:** [October 28, 2023, 4:08pm UTC](https://community.glideapps.com/t/distance-lookup-table/67163/3 "2023-10-28T16:08:16Z")

</div>

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.