Multiple drop-down lists dependent on the same source list (non-cascade)

%3CLINGO-SUB%20id%3D%22lingo-sub-2079038%22%20slang%3D%22en-US%22%3EMultiple%20drop-down%20lists%20dependent%20on%20the%20same%20source%20list%20(non-cascade)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2079038%22%20slang%3D%22en-US%22%3E%3CP%3EHello%20group.%20I%20am%20searching%20for%20a%20solution%20where%20multiple%20drop-down%20lists%20are%20dependent%20on%20the%20same%20reference%2Fsource.%3C%2FP%3E%3CP%3EFor%20example%3A%20the%20source%20is%20list%20of%20cities.%20Depending%20on%20the%20city%20selected%2C%20I%20want%20to%20determine%203%20more%20lists%3A%20restaurants%2C%20hotels%2C%20museums.%20These%20lists%20must%20be%20dependent%20on%20the%20city%20selected%20but%20not%20dependent%20on%20each%20other%20in%20cascade%20model.%3C%2FP%3E%3CP%3EI%20tried%20with%20INDIRECT%20function%20but%20it%20allows%20me%20to%20reference%20only%20one%20dependent%20list(for%20example%20restaurants)%20to%20one%20source%20(cities).%20Probably%20in%20a%20combination%20with%20another%20function%20I%20would%20be%20able%20to%20reference%20more%20that%20one%20dependent%20list%20to%20the%20same%20source.%3C%2FP%3E%3CP%3EThank%20you%20in%20advance%20for%20your%20help!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

Hello group. I am searching for a solution where multiple drop-down lists are dependent on the same reference/source.

For example: the source is list of cities. Depending on the city selected, I want to determine 3 more lists: restaurants, hotels, museums. These lists must be dependent on the city selected but not dependent on each other in cascade model.

I tried with INDIRECT function but it allows me to reference only one dependent list(for example restaurants) to one source (cities). Probably in a combination with another function I would be able to reference more that one dependent list to the same source.

Thank you in advance for your help!

 

0 Replies