Creating Lookup field for users to find route options...
I'm trying to create a Look up field where users can type in a starting location and an ending location and would be presented with results from our available routes. I assume I would need to use index and match but don't ton of expertise in this regard.
In other threads i see folks have suggested building out the source sheet which i have done and have attached. We have about 300 more rows to include but this example will give you the framework/idea.
But then i think i read you would need to build another supplementary sheet that has the "search field" with an embedded formula to query the source data when typed in...
Thank you :-)
Help Article Resources
Check out the Formula Handbook template!