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 ?
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))
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.