spread sheet use of Look function to automate collection of Grid refs from Find sheet.

matt moore

01 May 2020 10:45

Greetings,

I've just completed my initial, modest contribution of 10 routes.

I worked by pasting start,finish,name to a notefile, where I later also paste the route URL.

(pasting the URL saved me from an occurrence of the Route not found problem reported by others)

If there will be a furture substantial body of new routes, some streamlining could be achieved with automatic lookup of the grid refs from the Find sheet, using the Lookup or possibly Vlookup function. 

(experiments hampered by edit Protection, live working, and limited knowledge of googlesheets).

regards

 

Matt Moore

0

• 

  Slow Ways Support

  01 May 2020 13:34

  Thanks Matt. 

  Would love some of your thinking on the post about the future website! 

  -1

Please sign in to leave a comment.