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

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